Обсуждение: List Tables !

How can I see the list the tables for a database ?
There is a query like "show tables" ?
I have the same problems witdh other objects: triggers procedures.

What is the method for seeing this ?

thanks !

Catalin CIOCOIU wrote:
>
> How can I see the list the tables for a database ?
> There is a query like "show tables" ?
> I have the same problems witdh other objects: triggers procedures.
>
> What is the method for seeing this ?
>
> thanks !
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


List all tables \d

for more info on all commands do \?

Regards,
Boulat Khakimov

--
Nothing Like the Sun

"\dt" lists tables

"\?" gives a list of all the commands.

Poul L. Christiansen

Catalin CIOCOIU wrote:
>
> How can I see the list the tables for a database ?
> There is a query like "show tables" ?
> I have the same problems witdh other objects: triggers procedures.
>
> What is the method for seeing this ?
>
> thanks !
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

use the backslash commands.  see \? for a list of those commands.  I think the
particular command is \d or \dt.  is this your question?

Dax Duskin





Catalin CIOCOIU <catalin.ciocoiu@inpg.fr> on 03/08/2001 09:23:07 AM

To:   "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
cc:    (bcc: Dax Duskin/Evanston/ZSAssociates)

Subject:  [NOVICE] List Tables !



How can I see the list the tables for a database ?
There is a query like "show tables" ?
I have the same problems witdh other objects: triggers procedures.

What is the method for seeing this ?

thanks !

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org