Thread: SQL norm views to describes tables (and probably some other things) of a database ?
SQL norm views to describes tables (and probably some other things) of a database ?
From
"Bruno BAGUETTE"
Date:
Hello, I know that the SQL norm contains some views to describes the tables (and probably some other things) of a database. Does PostgreSQL implement theses views (from which version number) ? I don't find anything in the documentation about that. Thanks in advance ! --------------------------------------- Bruno BAGUETTE - pgsql-ml@baguette.net
Bruno BAGUETTE wrote: > Hello, > > I know that the SQL norm contains some views to describes the tables (and > probably some other things) of a database. > > Does PostgreSQL implement theses views (from which version number) ? I don't > find anything in the documentation about that. You meant this? http://www.postgresql.org/docs/7.4/static/information-schema.html HTH Shridhar
Re: SQL norm views to describes tables (and probably some other things) of a database ?
From
Troels Arvin
Date:
On Mon, 17 May 2004 09:32:49 +0200, Bruno BAGUETTE wrote: > I know that the SQL norm contains some views to describes the tables (and > probably some other things) of a database. > > Does PostgreSQL implement theses views (from which version number) ? I > don't find anything in the documentation about that. PostgreSQL v. 7.4 introduced INFORMATION_SCHEMA, which is probably what you are looking for: http://www.postgresql.org/docs/7.4/static/information-schema.html -- Greetings from Troels Arvin, Copenhagen, Denmark