Re: How does one get names of all tables in a DB

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: How does one get names of all tables in a DB
Date: 2005-03-21 03:20:35
Message-ID: 5.2.1.1.0.20050320221718.03816230@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?&nbsp; Run psql with the -E option to show you
the SQL behind any of its commands.&nbsp; Issue the \dt command to list
tables.&nbsp; Process the SQL through your favourite interface.</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 689 bytes

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Fuhr 2005-03-21 03:23:56 Re: How does one get names of all tables in a DB
Previous Message Michael Fuhr 2005-03-20 17:02:28 Re: Discovering privileges