> How can I retrieve the "names" of all the tables in my database ?
In Postgres 7:
>From psql: \dt
or \d for all objects
>From SQL:
select * from pg_tables where tablename not like 'pg_%';
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 n
Try typing "\dt" from the psql prompt of the database whose table list u
want
On Thu, 17 Aug 2000 [EMAIL PROTECTED] wrote:
> How can I retrieve the "names" of all the tables in my database ?
>
> TIA
>
How can I retrieve the "names" of all the tables in my database ?
TIA
