Received: from web502.yahoomail.com (web502.mail.yahoo.com [128.11.68.69])
	by hub.org (8.9.3/8.9.3) with SMTP id OAA95300
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 25 Aug 1999 14:12:25 -0400 (EDT)
	(envelope-from inkle99@yahoo.com)
Message-ID: <19990825181206.2047.rocketmail@web502.yahoomail.com>
Received: from [12.17.193.105] by web502.mail.yahoo.com;
	Wed, 25 Aug 1999 11:12:06 PDT
Date: Wed, 25 Aug 1999 11:12:06 -0700 (PDT)
From: inkle c <inkle99@yahoo.com>
Subject: how to get all the tables of a database?
To: pgsql-interfaces@postgreSQL.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hi,

I am trying to get all the tables within a database,
which is equivalent to commandline "select \dt" after "pgsql mydb" gets
connected. I need this to
be written in C/C++ program, it would be something
similar to myPgConnection.ExecCommandOk("select * from
mydb") according to my own naive thought. I know there
is a table pg_database(or whatever) which contains all
databases created, is there a correspondent in any
database, or what is the alternative way to get all
tables from the databases?

Thanks.

inkle
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com