James Sasitorn <james(at)sasitorn(dot)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 statements and supporting tables it corresponded to).
Yes. Use \d+ to see the definition too in recent versions of psql.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Soviet||Date: 2011-07-31 14:02:21|
|Subject: PostgreSQL on Amazon EC2/EBS|
|Previous:||From: James Sasitorn||Date: 2011-07-30 07:09:02|
|Subject: \d for views display query|