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: (view raw, whole thread or download thread mbox)
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,


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-2017 The PostgreSQL Global Development Group