Re: Created objects not visible

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Created objects not visible
Дата
Msg-id 1213.1125153604@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Created objects not visible  (Kretschmer Andreas <andreas_kretschmer@despammed.com>)
Список pgsql-novice
Kretschmer Andreas <andreas_kretschmer@despammed.com> writes:
> Alex du Plessis <alxdp@telkomsa.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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Kretschmer Andreas
Дата:
Сообщение: Re: Created objects not visible
Следующее
От:
Дата:
Сообщение: index: specify sort order?