sorry ... i didn't make myself clear ... i have of course come across \dt before ...
what i meant was via sql as in 'select tablelist from <some pg sys table perhaps ?>' Steve > -----Original Message----- > From: Stephane Schildknecht [mailto:[EMAIL PROTECTED]] > Sent: 11 July 2002 15:06 > To: Steve Brett > Subject: Re: [SQL] list of tables ? > > > Le jeu 11/07/2002 à 16:00, Steve Brett a écrit : > > 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 > > > > ta, > > > > Steve Brett > \d > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
