How to have the list of all tables names of a monetdb database ?
Hi everyone 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 ? Best regards, Fopa
Hi, Please take a look at: https://www.monetdb.org/Documentation/SQLcatalog/TablesColumns in your case: select * from sys.tables; Radovan On 04/11/2014 10:40 AM, Leon-Constantin Fopa wrote:
Hi everyone
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 ?
Best regards,
Fopa _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
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
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" <Hannes.Muehleisen@cwi.nl> À: users-list@monetdb.org Envoyé: Vendredi 11 Avril 2014 10:44:09 Objet: Re: How to have the list of all tables names of a monetdb database ? 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 _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Hannes Mühleisen -
Leon-Constantin Fopa -
Radovan Bičiště