| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Carmen Gloria Sepulveda Dedes <csepulveda(at)atichile(dot)com> |
| Cc: | "PostgreSQL [GENERAL] List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SQL Command - To List Tables ? |
| Date: | 2003-08-28 05:15:04 |
| Message-ID: | 20030828051504.GA7382@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Aug 27, 2003 at 09:17:01AM -0400, Carmen Gloria Sepulveda Dedes wrote:
> 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?
You need to change your search_path. Use
SET search_path TO 'one-schema', 'another', ...
Then repeat your \dt
Or IIRC you can also use
\dt *.*
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La espina, desde que nace, ya pincha" (Proverbio africano)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2003-08-28 05:26:21 | Re: Pg_dump : Can I specify the Password ? |
| Previous Message | Barry Lind | 2003-08-28 05:11:45 | Re: FATAL: Socket command type A unknown |