Re: Get list of tables in a database - Mailing list pgsql-general

% psql -E dbname
dbname=>\d

at the beginning of the output it will print out the query used to
generate the table list.

-E, --echo-hidden
              Echoes the actual queries generated by \d and other
              backslash commands.  You can use this if  you  wish
              to include similar functionality into your own pro-
              grams. This is equivalent to setting  the  variable
              ECHO_HIDDEN from within psql.

On Tue, 3 Dec 2002 Riyaz@umapinc.com wrote:

> Hi,
>
>       I am looking for a SQL query which will return me the names of all
> the tables in a database. I want to use this in my php page to generate a
> list of tables given the name of database.
>
> Thanks in advance,
> Riyaz