Thanks you guys !
Finally the following query do the job.
select tables.name from tables where tables.system=false ;
Thanks
----- Mail original -----
De: "Hannes Mühleisen"
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 _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list