Received: from lee.k12.nc.us (mail.lee.k12.nc.us [207.4.71.118]) by hub.org (8.8.8/8.7.5) with ESMTP id LAA14633 for ; Wed, 5 Aug 1998 11:46:05 -0400 (EDT) Received: by gateway.lee.k12.nc.us id <35713>; Tue, 4 Aug 1981 10:38:07 -0400 Date: Wed, 5 Aug 1998 11:49:00 -0400 From: James Olin Oden X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: James Andrews CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] How do I get the list of table names in db References: <3.0.32.19980805033804.006a9c30@pop.darkplaces.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <81Aug4.103807edt.35713@gateway.lee.k12.nc.us> > I need to know how to get a list of table names that exist in a particular > database using Pg. I know how to do it command line, but I need my scripts > to be able to do it for error checking, and I haven't found a single doc on > it. > > -james Well, here is one way. In your script issue the command: psql -c "\d" -o filename database_name depending on your scripting language you may need to wrap the command around some other command such as: system ("psql -c \"\\d\" -o filename database_name"); in perl. Now with this approach your script will then need to read in the file created by the -o switch. If your in perl you could do something like: open(COMMAND, "psql -c \"\\d\" database_name|") while () { print $_; } to not generate a file, and read in the standard output of the psql command. In the the Korn shell you could do: psql -c "\d" database_name| while read LINE do echo $LINE done Hope this helps...james