Re: really novice with Postgres !

On 2013-08-02 2: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
>
>
Off top of my head, \dt will get you list of tables and \d [tablename]
will show the structure...
You can type \? at psql prompt for more commands/etc.

Ziggy