Re: psql: no schema info

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: psql: no schema info
Date: 2008-04-28 17:01:37
Message-ID: 38117.57623.qm@web54302.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> > # \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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lodewijk Voege 2008-04-28 21:47:59 information_schema.referential_constraints permissions
Previous Message Emi Lu 2008-04-28 13:19:03 Re: trim(both) problem?