List columns for a table.

The database that the tables belong to must be in scope of GlareDB, for example as a data source.

For listing columns on a native table, use "default" as the database.


list_columns(<database>, <schema>, <table>)
Field Description
database The name of the database.
schema The name of the schema on the databsae.
table The name of the table to list columns for.


In the following example, suppose a Postgres data source was added to GlareDB and named my_pg:

-- list all columns of the public.customers table
select * from list_columns("my_pg", "public", "customers");

See CREATE EXTERNAL DATABASE for adding a database as a data source.