| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>, "Greg Copeland" <greg(at)CopelandConsulting(dot)Net> |
| Cc: | <greg(at)turnstep(dot)com>, "PostgresSQLHackers Mailing List" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: \d type queries - why not views in system catalog?!? |
| Date: | 2003-01-14 08:24:50 |
| Message-ID: | 03AF4E498C591348A42FC93DEA9661B8259A99@mail.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> -----Original Message-----
> From: Robert Treat [mailto:xzilla(at)users(dot)sourceforge(dot)net]
> Sent: 13 January 2003 22:01
> To: Greg Copeland
> Cc: Dave Page; greg(at)turnstep(dot)com; PostgresSQLHackers Mailing List
> Subject: Re: [HACKERS] \d type queries - why not views in
> system catalog?!?
>
>
> You have to do it in functions because some of the \ commands
> use multiple queries and logic inside the C code.
pgAdmin lists far more comprehensive data the psql and does it from
single queries 95% of the time. I'm sure someone more expert in SQL than
me could get pretty much all the other 5% sorted...
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sziklai Gabor | 2003-01-14 08:39:52 | Re: Warning on transaction commit |
| Previous Message | Christopher Kings-Lynne | 2003-01-14 04:23:59 | Re: copying perms to another user |