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

Re: \d for views display query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Sasitorn <james(at)sasitorn(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: \d for views display query
Date: 2011-07-30 15:07:14
Message-ID: 20801.1312038434@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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: SovietDate: 2011-07-31 14:02:21
Subject: PostgreSQL on Amazon EC2/EBS
Previous:From: James SasitornDate: 2011-07-30 07:09:02
Subject: \d for views display query

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