> -----Original Message----- > From: Rod Taylor [mailto:[EMAIL PROTECTED]] > Sent: 13 August 2002 13:03 > To: Dave Page > Cc: Johan Mjönes; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Problems viewing a table > called "user" inpgAdmin 1.3.6 > > > This would cost an extra query for every query, but you could > let the DB manage it with: > > select quote_ident('user'); > > > Just pile on all of the identifiers into a list and use the > results for the real query. This way it'll work across all > versions of Postgresql as well as future ones without any > changes required to the 'keylist'. Yeah, the problem is though that pgAdmin's own internal quote_ident (fmtID) is called in lterally hundreds of places. What would be handier would be a function that returns an array of keywords - that could be queried at logon and used to populate a dictionary. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 3: 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
