Skip site navigation (1) Skip section navigation (2)

Re: Created objects not visible

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: meDate: 2005-08-27 15:34:12
Subject: index: specify sort order?
Previous:From: Kretschmer AndreasDate: 2005-08-27 06:46:12
Subject: Re: Created objects not visible

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group