Skip site navigation (1) Skip section navigation (2)

Re: pulling my hair out..

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: David Bear <David(dot)Bear(at)asu(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pulling my hair out..
Date: 2004-11-05 00:50:33
Message-ID: 20041105005033.GA22481@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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/

In response to

pgsql-admin by date

Next:From: Allen SmithDate: 2004-11-05 02:31:02
Subject: Help with restore
Previous:From: Stephan SzaboDate: 2004-11-05 00:45:52
Subject: Re: pulling my hair out..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group