> -----Original Message-----
> From: Rod Taylor [mailto:rbt@zort.ca]
> Sent: 13 August 2002 13:03
> To: Dave Page
> Cc: Johan Mjönes; pgadmin-support@postgresql.org
> 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.
Whatwould be handier would be a function that returns an array of keywords - that could be queried at logon and used to
populatea dictionary.
Regards, Dave.