Tables Question
Started by Nonameover 26 years ago4 messagesgeneral
Stepping through
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
Import Notes
Reply to msg id not found: kfemps0vt6a966cv7h66u8d09cifdm0no1@4ax.com
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