[GENERAL] Getting list of tables used within a query

Hi, for need of our application we need to get list of tables, that are used within given SELECT query - we need them in order to track changes of the data, that may be returned by the query - it is some kind of caching mechanism, that checks db data modifications. Right now we create a temporary

Re: [GENERAL] Getting list of tables used within a query

Hello you need analyze execution plan - parser does know nothing about table order. look on EXPLAIN statement regards Pavel Stehule -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general