| From: | nconway(at)klamath(dot)dyndns(dot)org (Neil Conway) |
|---|---|
| To: | Ben Liblit <liblit(at)eecs(dot)berkeley(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org, Doug McNaught <doug(at)wireboard(dot)com> |
| Subject: | Re: dropping anonymous constraints |
| Date: | 2002-07-17 20:25:42 |
| Message-ID: | 20020717202542.GB6846@klamath.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jul 17, 2002 at 12:59:42PM -0700, Ben Liblit wrote:
> I guess this is the part I find suprising: the non-standardization of
> database meta-information. SQL is great for getting information *out*
> of a database, but seems to have a serious blind spot when it comes to
> fetching information *about* a database.
No, there are INFORMATION_SCHEMA views defined by SQL -- someone will
get around to implementing them one of these days.
The problem here is that (a) not everyone implements the SQL standard
views (b) the SQL standard stuff doesn't include PostgreSQL extensions,
obviously.
Cheers,
Neil
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeffrey Hood | 2002-07-17 20:31:29 | Query Performance... |
| Previous Message | Bruce Momjian | 2002-07-17 20:03:26 | Re: table size growing out of control |