\z will list the tables in the dbase
\d tablename will list the columns in the table
---------------------
Erik Wasser wrote:
>Hi list,
>
>how can I list the databases in a postgresish way? I know about the '-l'
>switch of 'psql' but is there a DBI/SQL-query way? I don't want to call
>an external program only to list the databases. I've googled about this
>problem but I only found the '-l'-way to this this.
>
>Ideas? Solutions?
>
>
>