| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
| Cc: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SQL Command - To List Tables ? |
| Date: | 2003-08-29 09:06:27 |
| Message-ID: | 20030829090627.GD23834@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bart | 2003-08-29 09:28:32 | Visual database structure browser for postgresql? |
| Previous Message | Richard Huxton | 2003-08-29 08:52:33 | Re: [SQL] Unique constraints for a list |