11 Apr
2014
11 Apr
'14
8:44 a.m.
Hi Leon-Constantin,
On 04/11/2014 10:40 AM, Leon-Constantin Fopa wrote:
In postgresql one can have all tables names by running the following query
SELECT table_name FROM information_schema.tables WHERE table_schema='public';
Is there something similar in monetdb to have the list of tables ?
Yes, there is the virtual "tables" table (and others).
If you want to filter by schema name, you can join with the "schemas" table as such:
select tables.name from tables join schemas on tables.schema_id=schemas.id where schemas.name='sys' ;
Best,
Hannes