| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com> |
| Cc: | andy(dot)shellam(at)mailnetwork(dot)co(dot)uk, "Christopher Browne" <cbbrowne(at)acm(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Show tables query |
| Date: | 2006-04-02 16:46:43 |
| Message-ID: | 23723.1143996403@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com> writes:
> information_schema is the standard which are more likely to behave
> the same in all versions of pgsql becoz they are(currently) views on
> the sys catalogs.
Unfortunately, the SQL committee did tremendous damage to that argument
by changing the definitions of some of those views in SQL2003 :-(
I'd still agree that the information_schema is less likely to change
than the underlying catalogs, but it's not an ironclad guarantee that
your app won't break.
(We haven't caught up to the SQL2003 behavior yet, but I believe Peter
Eisentraut is working on it for PG 8.2.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-04-02 17:31:51 | Re: FW: Setting up of PITR system. |
| Previous Message | Rajesh Kumar Mallah | 2006-04-02 16:14:58 | Re: FW: Setting up of PITR system. |