Skip site navigation (1) Skip section navigation (2)

\d for views display query

From: James Sasitorn <james(at)sasitorn(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: \d for views display query
Date: 2011-07-30 07:09:02
Message-ID: 5BFFB41A-16C2-413C-886A-DE2775280DBA@sasitorn.com (view raw or flat)
Thread:
Lists: 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 statements and 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

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2011-07-30 15:07:14
Subject: Re: \d for views display query
Previous:From: Michael SwierczekDate: 2011-07-29 18:49:43
Subject: Re: PostgreSQL on Amazon EC2/EBS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group