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)