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(at)students(dot)uiuc(dot)edu> wrote in message
news:Pine(dot)GSO(dot)4(dot)31(dot)0201311451080(dot)6396-100000(at)ux11(dot)cso(dot)uiuc(dot)edu(dot)(dot)(dot)
>
> 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
>
>