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

From Tom Lane
Subject Re: \d for views display query
Date
Msg-id 20801.1312038434@sss.pgh.pa.us
Whole thread Raw
In response to \d for views display query  (James Sasitorn <james@sasitorn.com>)
List pgsql-novice
James Sasitorn <james@sasitorn.com> writes:
> 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). 

Yes.  Use \d+ to see the definition too in recent versions of psql.

            regards, tom lane

pgsql-novice by date:

Previous
From: James Sasitorn
Date:
Subject: \d for views display query
Next
From: Soviet
Date:
Subject: PostgreSQL on Amazon EC2/EBS