From: | jwieck(at)debis(dot)com (Jan Wieck) |
---|---|
To: | vadim(at)krs(dot)ru (Vadim Mikheev) |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Re: [GENERAL] Views |
Date: | 1999-01-06 10:03:33 |
Message-ID: | m0zxpoM-000EBRC@orion.SAPserv.Hamburg.dsh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
>
> Kaare Rasmussen wrote:
> >
> > How can I see a view in psql after having created it? If I enter
> > \d <viewname> I can see the fields, but how can I see what makes up the
> > view? Best if the original CREATE statement could be listed somehow.
>
> We could use EXPLAIN VIEW for this...
> New item for TODO?
>
> EXPLAIN TABLE, EXPLAIN INDEX, etc
>
> Vadim
>
>
SELECT * FROM pg_views;
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #
From | Date | Subject | |
---|---|---|---|
Next Message | Silvio Emanuel Barbosa de Macedo | 1999-01-06 10:17:39 | Patch 6.4.1 to 6.4.2 |
Previous Message | Billy G. Allie | 1999-01-06 08:18:12 | Re: Stale porting list? |
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-01-06 10:19:38 | Re: [SQL] drop table in pgsql |
Previous Message | Michael Contzen | 1999-01-06 08:51:17 | PL/PGSQL bug when using aggregates (repost) |