thanks. Steve
> -----Original Message----- > From: Achilleus Mantzios [mailto:[EMAIL PROTECTED]] > Sent: 11 July 2002 15:10 > To: Steve Brett > Cc: Pgsql-Sql (E-mail) > Subject: Re: [SQL] list of tables ? > > > On Thu, 11 Jul 2002, 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 ? > > > > i'm on 7.2 > > select * from pg_tables; > > > > > ta, > > > > Steve Brett > > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > -- > Achilleus Mantzios > S/W Engineer > IT dept > Dynacom Tankers Mngmt > tel: +30-10-8981112 > fax: +30-10-8981877 > email: [EMAIL PROTECTED] > [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
