Re: really novice with Postgres !

Le 03/08/2013 19:53, Kevin Grittner a écrit :
> Jean MAURICE<mauricejea(at)numericable(dot)fr> wrote:
>
>> I can check if the database is present, if a table is present,
>> ... but how can I check if a schema is present (via ODBC; I can
>> see it in pgadmin3 !) ?
> See pg_catalog.pg_namespace or information_schema.schemata.
ok
> A SQL "schema" object is often called a "namespace".
registered !
>
> BTW, a subject line which is related to the question is a good idea
> -- you might have used "What system table or view for schemas?" or
> similar. Given the volume of posts to these lists, many people
> scan the list of subject lines and pick only some to read.
I'll pay attention to it
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
Thanks

--
Jean MAURICE
Grenoble - France - Europe
www.j-maurice.fr
www.atoutfox.org
www.aedtf.org
> -----
> Aucun virus trouvé dans ce message.
> Analyse effectuée par AVG - www.avg.fr
> Version: 2013.0.3392 / Base de données virale: 3209/6548 - Date: 03/08/2013
>
>
>