Thread: Tables Question

Tables Question

From
e411@altavista.com
Date:
How can I retrieve the "names" of all the tables in my database ?

TIA

Re: Tables Question

From
sridhvenk@yahoo.com
Date:
Try typing "\dt" from the psql prompt of the database whose table list u
want



On Thu, 17 Aug 2000 e411@altavista.com wrote:

> How can I retrieve the "names" of all the tables in my database ?
>
> TIA
>


Re: Tables Question

From
Gilles DAROLD
Date:
Hi,


> How can I retrieve the "names" of all the tables in my database ?

Not sure what you are using but if you use DBI perl interface you can
use
this two functions :

$sth = $dbh->table_info;
@names = $dbh->tables;

They works well with DBD::Pg.

In psql simply type \d..... this is certainly not what you are asking.

Regards


Re: Tables Question

From
"Glenn Tramm"
Date:
try ...mydatab=>\dt
good luck!

Glenn...
<e411@altavista.com> wrote in message
news:kfemps0vt6a966cv7h66u8d09cifdm0no1@4ax.com...
> How can I retrieve the "names" of all the tables in my database ?
>
> TIA