Unix Technical Forum

relations diagram of tables in the catalog system

This is a discussion on relations diagram of tables in the catalog system within the pgsql Hackers forums, part of the PostgreSQL category; --> Hi, i am new in this, and i need help with catalog system of postgresql, i need know how ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-15-2008, 11:29 PM
jaimelima@al.uap.edu.ar
 
Posts: n/a
Default relations diagram of tables in the catalog system

Hi,
i am new in this, and i need help with catalog system of postgresql, i need know
how are the relationship between the tables of the system catalog, and how work
each table, if anybody know about this please, answer me.

thank all of you.

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-15-2008, 11:29 PM
Josh Tolley
 
Posts: n/a
Default Re: relations diagram of tables in the catalog system

On 10/23/07, jaimelima@al.uap.edu.ar <jaimelima@al.uap.edu.ar> wrote:
> Hi,
> i am new in this, and i need help with catalog system of postgresql, i need know
> how are the relationship between the tables of the system catalog, and how work
> each table, if anybody know about this please, answer me.
>
> thank all of you.


The documentation is your friend. Refer to
http://www.postgresql.org/docs/8.2/i.../catalogs.html for
catalog table information specifically.

- Josh/eggyknap

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-15-2008, 11:29 PM
Alvaro Herrera
 
Posts: n/a
Default Re: relations diagram of tables in the catalog system

Josh Tolley escribió:
> On 10/23/07, jaimelima@al.uap.edu.ar <jaimelima@al.uap.edu.ar> wrote:
> > Hi,
> > i am new in this, and i need help with catalog system of postgresql, i need know
> > how are the relationship between the tables of the system catalog, and how work
> > each table, if anybody know about this please, answer me.
> >
> > thank all of you.

>
> The documentation is your friend. Refer to
> http://www.postgresql.org/docs/8.2/i.../catalogs.html for
> catalog table information specifically.


There's also this
http://www.postgresql.org/files/deve...ternalpics.pdf
(page 64)

It's a bit outdated ...

--
Alvaro Herrera http://www.PlanetPostgreSQL.org/
"I suspect most samba developers are already technically insane...
Of course, since many of them are Australians, you can't tell." (L. Torvalds)

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:54 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com