Michael C Rosenstein wrote: > > What is "schema" in this context? > > Oracle "schema" == Postgres "database": a collection of objects > (tables, functions, triggers, views, etc) owned by a user. That definition applies to an Oracle schema, but not to a postgres database. Objects inside a postgres database are not confined to a unique owner. Even objects inside the same postgres schema don't have that constraint. Also the analogy fails in that in Oracle you can refer to schema.object (which really means owner.object) whereas db.object doesn't work in postgres. Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
