Re: Generalized query to determine the table a query or a view's columns come from?

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.com