Postgres Pro
Downloads
Home   >   mailing lists

Re: psql: no schema info - Mailing list pgsql-sql

From chester c young
Subject Re: psql: no schema info
Date
Msg-id 38117.57623.qm@web54302.mail.re2.yahoo.com
Whole thread Raw
In response to Re: psql: no schema info  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
> > # \dt table1 -> does not show which schema info.

was wrong on this - \dt shows schema for relations _not_ in the search
path.

my new good practice is to keep search_path = PUBLIC so all schema info
is displayed always all the time invariably.


     ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Re: trim(both) problem?
Next
From: "Lodewijk Voege"
Date:
Subject: information_schema.referential_constraints permissions