\d for views display query - Mailing list pgsql-novice

From James Sasitorn
Subject \d for views display query
Date
Msg-id 5BFFB41A-16C2-413C-886A-DE2775280DBA@sasitorn.com
Whole thread Raw
Responses Re: \d for views display query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
The default behavior for \d (at least in my installations) changed when used against views.

if I do
#\d myview

It shows the view structure only. Older versions of psql used to also show what the view represented (the select
statementsand supporting tables it corresponded to). 

How do I display the select command/supporting tables backing a view in the interactive psql?


Thanks for the help,
James

pgsql-novice by date:

Previous
From: Michael Swierczek
Date:
Subject: Re: PostgreSQL on Amazon EC2/EBS
Next
From: Tom Lane
Date:
Subject: Re: \d for views display query