In Postgresql you must type :
pgsql <databasename>
Then type \dt.
All of your tables from the specified database will be listed.
Mircea
----- Original Message -----
From: "Fabio Ottolini (EDB)" <[EMAIL PROTECTED]>
To: "'Scott Fletcher'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 5:49 PM
Subject: RE: [PHP-DB] Viewing the DB
show tables;
Is that what you need? You want to list all tables of a certain database
right? Make sure to select the database using
use databasename;
before attempting to do this.
Best regards,
Fábio Ottolini
> -----Original Message-----
> From: Scott Fletcher [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 24, 2001 1:40 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Viewing the DB
>
>
> Does anyone know what is the sql command that would allow me
> to view all of
> the tables in the database?
>
> Scott
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]