psql -l
will list the databases.
psql <database name> will give to access to the command line sql environment
and once you're in there /dt will list the tables ...
Steve
"D'laila Pereira" <dpereira@students.uiuc.edu> wrote in message
news:Pine.GSO.4.31.0201311451080.6396-100000@ux11.cso.uiuc.edu...
>
> After a database is created in postgresql using the createdb command,
> and populate it with some taqbles, how do we test the existence of the
> database and the tables within it?
>
> thanks
> d'laila
>
>