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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
