Thread: Tables Question

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

TIA

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
>

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

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