From: Ian Barwick <ian.barwick@2ndquadrant.com>
To: jobyjc@gmail.com, pgsql-docs@lists.postgresql.org, PG Doc comments form <noreply@postgresql.org>
Subject: Re: Objects without schema
Date: Fri, 30 Nov 2018 10:44:42 +0900
Message-ID: <55aeb849-4cea-ef50-9076-db5703220548@2ndquadrant.com> (raw)
In-Reply-To: <154351247845.1315.1692288968604791039@wrigleys.postgresql.org>
References: <154351247845.1315.1692288968604791039@wrigleys.postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: ian.barwick@2ndquadrant.com, noreply@postgresql.org
Subject: Re: Objects without schema
In-Reply-To: <55aeb849-4cea-ef50-9076-db5703220548@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox