[GENERAL] DB structure of PostGRE

2006-05-17 Thread venu Vempati 
Hi,my confession first..I have introduced myself this PostGRE db and I have a basic doubt?Where can I find a document about the structure of database/schema/users etc..and how is the data actually stored, like the datafiles, tablespaces.
by now you must have guessed I have some knowledge of Oracle..(oops can I use thisname here??!!)Thanks for your feedback.Just a link to a document should be OK to start with, if someone is taking pain to explain, most welcome :))
Regards..--Venu

Re: [GENERAL] DB structure of PostGRE

2006-05-17 Thread Terry Lee Tucker 
On Wednesday 17 May 2006 12:19 pm, venu Vempati [EMAIL PROTECTED] 
thus communicated:
-- Hi,
-- my confession first..I have introduced myself this PostGRE db and I have
 a -- basic doubt?
--
-- Where can I find a document about the structure of database/schema/users
-- etc..
-- and how is the data actually stored, like the datafiles, tablespaces.
-- by now you must have guessed I have some knowledge of Oracle..(oops can I
-- use thisname here??!!)
-- Thanks for your feedback.Just a link to a document should be OK to start
-- with, if someone is taking pain to explain, most welcome :))
-- Regards..
-- --Venu
--

http://www.postgresql.org/ has all sorts of documentation regarding the 
questions you ask.

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] DB structure of PostGRE

2006-05-17 Thread Tom Lane 
venu Vempati [EMAIL PROTECTED] writes:
 Where can I find a document about the structure of database/schema/users
 etc..
 and how is the data actually stored, like the datafiles, tablespaces.

http://developer.postgresql.org/docs/postgres/storage.html

regards, tom lane

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster