From: | Jean MAURICE <mauricejea(at)numericable(dot)fr> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: really novice with Postgres ! |
Date: | 2013-08-02 13:31:44 |
Message-ID: | 51FBB4C0.7020205@numericable.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi Tovo,
I saw there is a view 'tables' that gives the list of the tables. How do we use
a view in Postgres ?
I tried
SELECT * FROM tables;
but the error is something like 'the relation 'tables' doesn't exist' (my
Postgres is in French !)
Best regards
--
Jean MAURICE
Grenoble - France - Europe
www.j-maurice.fr
www.atoutfox.org
www.aedtf.org
Le 02/08/2013 15:01, Tovo Rabemanantsoa a écrit :
> On 08/02/2013 02:51 PM, Jean MAURICE wrote:
>> Hi everybody,
>>
>> I have some more questions :
>> Is there a SQL command to
>> - test if a database exists
>> - test if a table exists
>> - get the list of the tables of a database
>> - get the structure (list of fields) of a table
>>
>> Thanks in advance
>>
>> --
>> Jean MAURICE
>> Grenoble - France - Europe
>> www.j-maurice.fr
>> www.atoutfox.org
>> www.aedtf.org
>>
>>
> Hello Jean,
> With Postgresql, you have something called information schema [1].
> In that, you will find all the informations you need about you
> databases, tables and so on.
> Cheers
>
> [1]http://www.postgresql.org/docs/current/static/information-schema.html
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tovo Rabemanantsoa | 2013-08-02 13:42:07 | Re: really novice with Postgres ! |
Previous Message | Jean MAURICE | 2013-08-02 13:07:38 | Re: really novice with Postgres ! |