| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | "mauricejea(at)numericable(dot)fr" <mauricejea(at)numericable(dot)fr>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: really novice with Postgres ! |
| Date: | 2013-08-03 17:53:43 |
| Message-ID: | 1375552423.12957.YahooMailNeo@web162906.mail.bf1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
A SQL "schema" object is often called a "namespace".
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.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean MAURICE | 2013-08-03 18:08:36 | Re: really novice with Postgres ! |
| Previous Message | Jean MAURICE | 2013-08-03 07:48:35 | really novice with Postgres ! |