On Thursday 11 July 2002 16:00, Steve Brett wrote:
> can anyone point me in the right direction ?
>
> i need to list all the tables in a database.
>
> i've looked at pgadmin_tables which is empty and pga_schema whihc contains
> a sinlge row i don't want to parse ...
>
> is there an easier way t get a list of tables ?
Start psql with the -E option and issue \dt
This gives you the statement(s) used internally by psql.
Ian Barwick