| From: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
|---|---|
| To: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: cannot EXPLAIN query... |
| Date: | 2003-02-03 15:59:03 |
| Message-ID: | 200302032129.03746.mallah@trade-india.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Monday 03 February 2003 09:20 pm, Christoph Haller wrote:
> > Sorry Postgresql has really made my VIEWS ugly.
> > It wasnt' so when i fed them.
> >
> > I wish pgsql stores the create view defination some day ,
> > just like it does for indexes (pg_get_indexdef)
>
> Did you ever try
>
> SELECT * FROM pg_views ;
i thing when you do a \d <view_name> it uses that only.
in any case i have verified that the content in them are equally
messed up.
regds
mallah.
>
> It definitely has all view definitions.
>
> Regards, Christoph
--
--------------------------------------------
Regds Mallah
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)26152172 (221) (L) 9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah. | 2003-02-03 16:32:38 | Re: cannot EXPLAIN query... |
| Previous Message | Rajesh Kumar Mallah. | 2003-02-03 15:54:09 | Re: cannot EXPLAIN query... |