Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4SCSiA92386 for ; Mon, 28 May 2001 08:28:44 -0400 (EDT) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4PKRvA09331 for ; Fri, 25 May 2001 16:27:57 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4PKRUc62383 for pgsql-interfaces@postgresql.org; Fri, 25 May 2001 16:27:30 -0400 (EDT) (envelope-from news) From: "Erny" X-Newsgroups: comp.databases.postgresql.interfaces Subject: Meta info for queries Date: Fri, 25 May 2001 22:30:25 +0200 Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Original-NNTP-Posting-Host: 212.166.170.33 Message-ID: <3b0ec030@news> To: pgsql-interfaces@postgresql.org X-Archive-Number: 200105/118 X-Sequence-Number: 1648 Hi all, I would like to write an table and query editor for Posgresql á la pgAccess. But I would need some help from postgresql to make it work smarter. Are there functions / switches to get the following information: * Effective Tables included in the query (a query could call views or stored procedures or whatever so I need info after Postgresql Rewrite unit has done its job) * Effective fields, that is source table and field for each of the output fields. Columns calculated from functions should not specify this or make it clear that this is not a direct output. * Return all oids, although not explicitly specified in queries. * The same for xmin (row versioning) In MS-Access: * primary keys are used to access rows in tables and queries * There is an internal row versioning. * Processes Joins in the ODBC layer, i.e., does only query tables and joins the results at the client. Thanx, Erny