Andreas Pflug disse:
> min@pse-consulting.de> wrote:
>
>>
>> I didn't enter " in the name field. The login name is stevie-o.
>> Because the hyphen is treated as a token separator, the grant
>> statement (as SQL) needs to look like this:
>>
>> GRANT SELECT ON TABLE foo TO "stevie-o"
>>
>> But when pgAdmin3 tries to show the SQL that would recreate table foo,
>> it appears to be adding two additional pairs of quotation marks.
>>
>
> Can anybody check this on 7.4? On 8.0 the acl has \" in it, seems this
> is new.
>
> Regards,
> Andreas
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
This is pgadmin3 (2004/08/17) with PostgreSQL 7.4.3. It shows:
GRANT SELECT ON TABLE foo TO "\""stevie-o\""";
after I used this on psql:
GRANT SELECT ON TABLE foo TO "stevie-o";
--
Giovanni P. Tirloni