Re: SQL Command - To List Tables ? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: SQL Command - To List Tables ?
Date
Msg-id 20030829090627.GD23834@svana.org
Whole thread Raw
In response to Re: SQL Command - To List Tables ?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On Thu, Aug 28, 2003 at 04:31:16AM -0500, Ron Johnson wrote:
>
> Isn't that big CASE statement unnecessary, since you also have
>   c.relkind IN ('r','')

Not really. In the code almost all the \d commands use that same query but
just change the "relkind in" clause.

So you can see it's redundant on a local level but the code that generates
it doesn't need to know.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato

Attachment

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [SQL] Unique constraints for a list
Next
From: Richard Huxton
Date:
Subject: Re: Functions have 32 args limt ???