Re: SQL Command - To List Tables ? - Mailing list pgsql-general

From Carmen Gloria Sepulveda Dedes
Subject Re: SQL Command - To List Tables ?
Date
Msg-id 3F4CAF4D.DE23478E@atichile.com
Whole thread Raw
In response to SQL Command - To List Tables ?  (Peter Moscatt <pgmoscatt@optushome.com.au>)
Responses Re: SQL Command - To List Tables ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: SQL Command - To List Tables ?  (Heath Tanner <heatht@interport.net>)
Re: SQL Command - To List Tables ?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Hello.  I type \dt as user postgres, but it show only the tables within
public schema.  I need to know all tables (like v$_  or dba_ or user_
in oracle).   How I do that?
Thanks.

Robby Russell wrote:

> Peter Moscatt wrote:
> >Is there a SQL command I can issue which will list all the TABLES within
> >a database ?
>
> Well, when you are the postgres commandline client, you can type
>   #  \dt
>
> That will show all the tables in your current database.


pgsql-general by date:

Previous
From: Joe Lester
Date:
Subject: Embedding Postgres "inside" an application
Next
From: Andrew Sullivan
Date:
Subject: Re: Postgresql for Solaris on Sparc