List tables for a schema.

The database where the schema resides must be in scope of GlareDB, for example as a data source.


list_tables(<database>, <schema>)
Field Description
database The name of the database.
schema The name of the schema to list tables for.


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

select * from list_tables(my_pg, public);

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