Re: pulling my hair out.. - Mailing list pgsql-admin

On Thu, Nov 04, 2004 at 05:07:20PM -0700, David Bear wrote:
>
> npcenter=# grant all on table 'contactNames' to group npcenter;
> ERROR:  syntax error at or near "'contactNames'" at character 20

Try double quotes:

grant all on table "contactNames" to group npcenter;

http://www.postgresql.org/docs/7.3/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/