Meta info for queries
| От | Erny |
|---|---|
| Тема | Meta info for queries |
| Дата | |
| Msg-id | 3b0ec030@news обсуждение исходный текст |
| Список | 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
В списке pgsql-interfaces по дате отправления: