Thread: Objects without schema

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.

Thanks,
Joby

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