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
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

In response to

Browse pgsql-novice by date

  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