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

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

From
"Dave Page"
Date:

> -----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.