Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > psql: no schema...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 3441 of 3559
Post > Topic >>

psql: no schema info

by chestercyoung@[EMAIL PROTECTED] (chester c young) Apr 27, 2008 at 02:33 PM

have several schemae, each with identical tables.

in create scripts have been taking great care to fully qualify, eg,
  col1 references schema1.tab1( col1 )

however, just got burnt big time on sequences!  need to qualify them as
well, eg
  col1 integer default nextval( 'schema1.seq1' )

\dt is no help at all since it does not specify schema so it's
impossible to know if all is aligned correctly.  is there a way to tell
psql to fully qualify relations in the listing?

when everything was in public this wasn't a problem, but with elaborate
use of schemae it's pretty scary (for me).


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

-- 
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
 




 6 Posts in Topic:
psql: no schema info
chestercyoung@[EMAIL PROT  2008-04-27 14:33:33 
Re: psql: no schema info
tgl@[EMAIL PROTECTED] (T  2008-04-27 18:36:59 
Re: psql: no schema info
chestercyoung@[EMAIL PROT  2008-04-27 16:33:26 
Re: psql: no schema info
dev@[EMAIL PROTECTED] (R  2008-04-28 08:30:09 
Re: psql: no schema info
chestercyoung@[EMAIL PROT  2008-04-28 10:01:37 
Re: psql: no schema info
alvherre@[EMAIL PROTECTED  2008-04-27 20:05:41 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 16:30:59 CDT 2008.