schema question

Started by Heine Ferreiraabout 14 years ago2 messagesgeneral
Jump to latest
#1Heine Ferreira
heine.ferreira@gmail.com

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.

In reply to: Heine Ferreira (#1)
Re: schema question

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