Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: unknown_filename
Description: text/html (689 bytes)

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group