Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 28 Apr 2008 10:01:37 -0700 (PDT)
- Message-id: <38117(dot)57623(dot)qm(at)web54302(dot)mail(dot)re2(dot)yahoo(dot)com>
> > # \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
- References:
- Re: psql: no schema info
- From: Richard Huxton
- Re: psql: no schema info
- Prev by Date: Re: trim(both) problem?
- Next by Date: information_schema.referential_constraints permissions
- Previous by thread: Re: psql: no schema info
- Next by thread: Re: psql: no schema info
- Indexes: