This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold
--------------------------------------------------------------------------- Greg Sabino Mullane wrote: > (oops, this time with -c, thanks Alvaro) > > Full support for all schema and table name combinations when > getting a list of attributes. All of the following will now work: > > select * from information_schema.columns where <tab> > select * from foo where <tab> > select * from "user" where <tab> > select * from "foo" where <tab> > select * from "Uppercase".lower where <tab> > select * from "gtsm.com"."foo.Bar" where <tab> > select * from "GTSM.com".foo where <tab> > > Also applies to other places that get lists of columns: insert into, > alter table, create index, etc. > > -- > Greg Sabino Mullane [EMAIL PROTECTED] > PGP Key: 0x14964AC8 200710211532 > http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 > [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings