From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Kretschmer Andreas <andreas_kretschmer(at)despammed(dot)com> |
Cc: | Alex du Plessis <alxdp(at)telkomsa(dot)net>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Created objects not visible |
Date: | 2005-08-27 14:40:04 |
Message-ID: | 1213.1125153604@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Kretschmer Andreas <andreas_kretschmer(at)despammed(dot)com> writes:
> Alex du Plessis <alxdp(at)telkomsa(dot)net> schrieb:
>> I run server v8.0 on an XP box and when I create new schems and tables in a
>> database with PGAdminIII they seem to create ok. Unfortunately, everything
>> created is not visible outside of PGAdminIII. can't even see anything with
>> psql. What am I doing wrong?
> I guess, you must set the search_path to the correct schema.
Or it might be simpler yet: maybe Alex is connecting to a different
database (within the same installation) with psql than he is with
PGAdmin.
What exactly do you mean by "not visible"? What operations did you try
to use to access the new objects?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | me | 2005-08-27 15:34:12 | index: specify sort order? |
Previous Message | Kretschmer Andreas | 2005-08-27 06:46:12 | Re: Created objects not visible |