From: | "Erny" <aerd(at)mx3(dot)redestb(dot)es> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Meta info for queries |
Date: | 2001-05-25 20:30:25 |
Message-ID: | 3b0ec030@news |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Randall Jonasz | 2001-05-25 23:43:27 | Re: C++ usage question |
Previous Message | J. T. Vermeulen | 2001-05-25 16:33:08 | Re: libpq++ and strings. |