Re: \d tablename with psql over slow links...

thank you.

On Monday 24 February 2003 09:25 am, Tom Lane wrote:
> <mallah(at)trade-india(dot)com> writes:
> > I observed that a table which used to take 16 secs with \d was only
> > taking 6 secs if the query for default attribute values are shifted to
> > top level query in psql/describe.c ( function describeOneTableDetails )
> > .
>
> I've applied this patch with some small improvements (to shortcircuit
> the sub-SELECT for columns with no default).
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--

Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.