Re: knowing which table/schema is going to be chosen

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: knowing which table/schema is going to be chosen
Дата
Msg-id 24211.1258038029@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: knowing which table/schema is going to be chosen  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> BTW I think I've spotted an error in the docs:
> http://www.postgresql.org/docs/8.3/interactive/ddl-schemas.html
> http://www.postgresql.org/docs/8.4/interactive/ddl-schemas.html

> 5.7.2. The Public Schema
>  In the previous sections we created tables without specifying any
>  schema names. By default, such tables (and other objects) are
>  automatically put into a schema named "public". Every new database
>  contains such a schema. Thus, the following are equivalent: ...

"By default" means "assuming you're using the default search_path".
However saying that here, where we haven't explained search_path yet,
wouldn't be an improvement IMO.

            regards, tom lane

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: DB Restart
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What is the simpliest text search configuration?