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
What exactly do you mean by "not visible"? What operations did you try
to use to access the new objects?
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: me||Date: 2005-08-27 15:34:12|
|Subject: index: specify sort order?|
|Previous:||From: Kretschmer Andreas||Date: 2005-08-27 06:46:12|
|Subject: Re: Created objects not visible|