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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings