pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedHow does one get names of all tables in a DB
3+ messages / 3 participants
[nested] [flat]
* How does one get names of all tables in a DB
@ 2005-03-16 22:41 Clay, Bruce <bclay@ball.com>
0 siblings, 1 reply; 3+ messages in thread
From: Clay, Bruce @ 2005-03-16 22:41 UTC (permalink / raw)
To: pgsql-interfaces
I have looked through all of the documentation could find and still can
not find out how to get names of all tables in a specified DB.
Is there a way through libpq c interface or through a SQL message sent
through pqexec to get a list of all of the tables in a given DB?
Bruce
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How does one get names of all tables in a DB
@ 2005-03-21 03:20 Frank Bax <fbax@sympatico.ca>
0 siblings, 0 replies; 3+ messages in thread
From: Frank Bax @ 2005-03-21 03:20 UTC (permalink / raw)
To: pgsql-interfaces
<html>
<body>
At 05:41 PM 3/16/05, Clay, Bruce wrote:<br>
<blockquote type=cite class=cite cite><font face="arial" size=2>I have
looked through all of the documentation could find and still can not find
out how to get names of all tables in a specified DB.<br>
</font><br>
<font face="arial" size=2>Is there a way through libpq c interface or
through a SQL message sent through pqexec to get a list of all of the
tables in a given DB?</font></blockquote><br><br>
Do you have access to CLI? Run psql with the -E option to show you
the SQL behind any of its commands. Issue the \dt command to list
tables. Process the SQL through your favourite interface.</body>
</html>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How does one get names of all tables in a DB
@ 2005-03-21 03:23 Michael Fuhr <mike@fuhr.org>
parent: Clay, Bruce <bclay@ball.com>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Fuhr @ 2005-03-21 03:23 UTC (permalink / raw)
To: Clay, Bruce <bclay@ball.com>; +Cc: pgsql-interfaces
On Wed, Mar 16, 2005 at 05:41:39PM -0500, Clay, Bruce wrote:
> I have looked through all of the documentation could find and still can
> not find out how to get names of all tables in a specified DB.
See the "System Catalogs" chapter. Here's a link to the latest
version:
http://www.postgresql.org/docs/8.0/interactive/catalogs.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-03-21 03:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-16 22:41 How does one get names of all tables in a DB Clay, Bruce <bclay@ball.com>
2005-03-21 03:23 ` Michael Fuhr <mike@fuhr.org>
2005-03-21 03:20 Re: How does one get names of all tables in a DB Frank Bax <fbax@sympatico.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox