On Tue, 2008-02-05 at 16:10 -0800, johnf wrote:
> I create a table named "Account_Text_Table" the owner is 'johnf'.
>
> select has_table_privilege('johnf', 'public.Account_Text_Table', 'SELECT')
> I get the following error:
>
> ERROR: relation "public.account_text_table" does not exist
PostgreSQL folds to lower case unless you put the name in double-quotes.
Try putting the table name in double-quotes.
E.g.: select has_table_privilege('johnf', 'public."Account_Text_Table"',
'SELECT')
Regards,
Jeff Davis