Re: Generalized query to determine the table a query or a view's columns come from?
From: Bob Hairgrove <invalid_at_bigfoot.com>
Date: Sat, 04 Mar 2006 00:59:56 +0100
Message-ID: <21mh02pohg2drop3iitd800lpc8065br8a_at_4ax.com>
Date: Sat, 04 Mar 2006 00:59:56 +0100
Message-ID: <21mh02pohg2drop3iitd800lpc8065br8a_at_4ax.com>
On Sat, 04 Mar 2006 00:45:17 +0100, Bob Hairgrove <invalid_at_bigfoot.com> wrote:
>Try the SQL command "describe xxx" and substitute the view name
>(perhaps prefixed by the schema name) for xxx.
Sorry, in ANSI SQL it would be "describe table ...", but in PostgreSQL you need something like "\d+ [table or view name]".
I never did this in PostgreSQL myself.
-- Bob Hairgrove NoSpamPlease_at_Home.comReceived on Sat Mar 04 2006 - 00:59:56 CET