I saw with PGAdmin that there is a public schema in the default postgres database. Does every database have a public schema? What is a schema and can you create your own?
On 19/01/2012 20:14, Heine Ferreira wrote:
> Hi
>
> I saw with PGAdmin that there is a public schema in the default postgres
> database.
> Does every database have a public schema?
Yes.
> What is a schema and can you create your own?
A schema is a means of making logical divisions within your database.
Read all about it here:
http://www.postgresql.org/docs/9.1/static/sql-createschema.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie