From: | Philip Hallstrom <philip(at)adhesivemedia(dot)com> |
---|---|
To: | Riyaz(at)umapinc(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Get list of tables in a database |
Date: | 2002-12-03 20:36:51 |
Message-ID: | 20021203123554.M77197-100000@cypress.adhesivemedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)umapinc(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Wynn, Robin | 2002-12-03 20:43:09 | Re: Backend message type 0x50 arrived while idle |
Previous Message | scott.marlowe | 2002-12-03 20:35:19 | Re: Backend message type 0x50 arrived while idle |