Thread: schema question

Hi

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?

Thanks

H.F.

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