X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B801832A182 for ; Wed, 6 Oct 2004 10:06:55 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23781-02 for ; Wed, 6 Oct 2004 09:06:51 +0000 (GMT) Received: from mail.gmx.net (pop.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 0945132A153 for ; Wed, 6 Oct 2004 10:06:49 +0100 (BST) Received: (qmail 30864 invoked by uid 65534); 6 Oct 2004 09:06:48 -0000 Received: from flnb-d9b897b3.pool.mediaWays.net (EHLO [217.184.151.179]) (217.184.151.179) by mail.gmx.net (mp012) with SMTP; 06 Oct 2004 11:06:48 +0200 X-Authenticated: #23867346 Message-ID: <4163B5A8.4090503@gmx.de> Date: Wed, 06 Oct 2004 11:06:48 +0200 From: =?ISO-8859-1?Q?Bj=F6rn_Lietz-Spendig?= User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: NEWBIE Query the PG8 Systemtables pg_xxx Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/14 X-Sequence-Number: 5109 Hi folks, It is my intention to create a visual DB-Designer for PostgreSQL 8 based on libpg.dll. One of the first things I want to do is to query the "systemtables". AFAIK the hierachy is server-database-schema-tables-columns etc. My questions : 1) is there a "Systemtables (pg_xxx)" ER Model available ? Where ? 2) What is the glue (key-foreign key) between the tables ? The oid ? 3) what the heck is a schema good for. ? If anybody can provide me an SQL example how o query a database to get the associated tables and its rows it would be a great help. As announced in the Subject : I am a PG newbie, so any hints are welcome. Borke Lietz