Andreas Pflug disse: > [EMAIL PROTECTED]> 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 [EMAIL PROTECTED] >
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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
