Received: from linux.stuco.uni-klu.ac.at (IDENT:qmailr@linux.stuco.uni-klu.ac.at [143.205.200.10]) by hub.org (8.9.2/8.9.1) with SMTP id DAA40633 for ; Sat, 6 Mar 1999 03:41:51 -0500 (EST) (envelope-from mmoedern@linux.stuco.uni-klu.ac.at) Received: (qmail 19395 invoked from network); 6 Mar 1999 08:41:39 -0000 Received: from kungfu.stuco.uni-klu.ac.at (HELO linux.stuco.uni-klu.ac.at) (143.205.200.98) by linux.stuco.uni-klu.ac.at with SMTP; 6 Mar 1999 08:41:39 -0000 Message-ID: <36E0EA4E.E1C6BAE@linux.stuco.uni-klu.ac.at> Date: Sat, 06 Mar 1999 09:41:50 +0100 From: Martin =?iso-8859-1?Q?M=F6derndorfer?= Organization: IMAF Branch Austria X-Mailer: Mozilla 4.5 [en] (Win95; I) X-Accept-Language: de-AT,en,ja,ko MIME-Version: 1.0 To: pgsql-admin@postgreSQL.org, pgsql-general@postgreSQL.org, pgsql-hackers@postgreSQL.org, pgsql-sql@postgreSQL.org Subject: ER, OMT chart of a database Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, e.g. create table super (name varchar(50)); create table sub (val int4) inherits (super); create table second (name varchar(50), supernr int4 references super(oid)); is there any way to get a chart (er, omt), etc. out of a database? I know that this would be a great programming work but are there any already fixed solutions? The output does not have to be "graphically" a kind of textinfo like: "super is a superclass of sub and offers name to sub" or "table second has a field supernr which is a foreign key of super" would be okay too. MArtin