Tables Question

Started by Nonameover 26 years ago4 messagesgeneral
Jump to latest
#1Noname
sridhvenk@yahoo.com
In reply to: Noname (#2)
Re: Tables Question

Try typing "\dt" from the psql prompt of the database whose table list u
want

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

Show quoted text

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

TIA

#2Noname
e411@altavista.com

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

TIA

#3Gilles Darold
gilles@darold.net
In reply to: Noname (#2)
Re: Tables Question

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

#4Glenn Tramm
glenn.tramm@iie.nl
In reply to: Noname (#2)
Re: Tables Question

try ...mydatab=>\dt
good luck!

Glenn...
<e411@altavista.com> wrote in message
news:kfemps0vt6a966cv7h66u8d09cifdm0no1@4ax.com...

Show quoted text

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

TIA