Re: [GENERAL] Views

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To:
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Views
Date: 1999-01-06 01:58:09
Message-ID: 3692C330.42B88AF@krs.ru
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

In response to

  • Views at 1999-01-05 19:04:10 from Kaare Rasmussen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1999-01-06 02:21:39 Re: [HACKERS] Re: [GENERAL] Views
Previous Message The Hermit Hacker 1999-01-05 21:37:28 Re: [GENERAL] Should I upgrade Postgres?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 1999-01-06 02:07:53 Re: [HACKERS] SQLJ
Previous Message Bruce Momjian 1999-01-06 01:30:03 Re: [HACKERS] FOR SHARE LOCK clause ?]