Re: Viewing the DB
| From: | Mircea Romanitan | Date: | Wed, 24 Jan 2001 15:57:52 +0000 |
| Subject: | Re: Viewing the DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6137@lists.php.net to get a copy of this message | ||
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)" <fabio.ottolini@edb.ericsson.se>
To: "'Scott Fletcher'" <scott@abcoa.com>
Cc: <php-db@lists.php.net>
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:scott@abcoa.com]
> Sent: Wednesday, January 24, 2001 1:40 PM
> To: php-db@lists.php.net
> 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>