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