Re: Problems viewing a table called "user" inpgAdmin 1.3.6

> -----Original Message-----
> From: Rod Taylor [mailto:rbt(at)zort(dot)ca]
> Sent: 13 August 2002 13:03
> To: Dave Page
> Cc: Johan Mjönes; pgadmin-support(at)postgresql(dot)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. 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.