Subject: Re: Objects without schema
To: jobyjc@gmail.com, pgsql-docs@lists.postgresql.org,
 PG Doc comments form <noreply@postgresql.org>
References: <154351247845.1315.1692288968604791039@wrigleys.postgresql.org>
From: Ian Barwick <ian.barwick@2ndquadrant.com>
Message-ID: <55aeb849-4cea-ef50-9076-db5703220548@2ndquadrant.com>
Date: Fri, 30 Nov 2018 10:44:42 +0900
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <154351247845.1315.1692288968604791039@wrigleys.postgresql.org>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

On 11/30/2018 02:27 AM, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/9.5/ddl-schemas.html
> Description:
> 
> In the last section of the document it says 'If you need to work with those
> systems, then maximum portability would be achieved by not using schemas at
> all.'.
> But how do we achieve this? If I am not mistaken, all objects(like tables)
> created in the database need to be created under one schema.

Correct, in that every object has to have a schema, by default the "public"
schema.

I suspect what this is trying to say is that you should keep all objects under
one schema, and not explicitly reference that schema; that way queries and DDL
would be more portable.


Regards

Ian Barwick

-- 
  Ian Barwick                   http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services