Re: knowing which table/schema is going to be chosen - Mailing list pgsql-general

From Tom Lane
Subject Re: knowing which table/schema is going to be chosen
Date
Msg-id 24211.1258038029@sss.pgh.pa.us
Whole thread Raw
In response to Re: knowing which table/schema is going to be chosen  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: DB Restart
Next
From: Tom Lane
Date:
Subject: Re: What is the simpliest text search configuration?