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