Understanding Schema's

From: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Understanding Schema's
Date: 2010-12-15 00:08:33
Message-ID: AANLkTikoEy_MxJhVr+6Z9UEFnrN5sopQKBzL6er=F_hx@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've recently switched from MySQL & have read the documentation for
'schema's' however I guess I'm just not at that level or really daft
when it comes to database design.

http://www.postgresql.org/docs/current/static/ddl-schemas.html

I'm trying to understand the relation between actual databases &
tables but can't grasp the relation with schema's so I was wondering
if someone has an easy way of explaining this beyond the documentation
I linked above. I notice my fresh 9.0 install has a default schema
called 'public' which every newly database I create defaults to and I
also created two new schema's called 'fire' & 'ice' but from what I
have written above, obviously I don't have any understanding of how
they work.

I greatly appreciate any info and or help since I appear to be lost.

-Carlos

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-12-15 00:17:28 Re: Understanding Schema's
Previous Message Fujii Masao 2010-12-15 00:05:17 Re: Hot Standby pg_xlog problem