Thread: DB structure of PostGRE

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

On Wednesday 17 May 2006 12:19 pm, "venu Vempati" <venu.vempati@gmail.com>
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.

"venu Vempati" <venu.vempati@gmail.com> 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