Re: ALTER syntax question and usernames with hyphens - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: ALTER syntax question and usernames with hyphens
Date
Msg-id 20071126200835.GB22964@alvh.no-ip.org
Whole thread Raw
In response to ALTER syntax question and usernames with hyphens  (Madison Kelly <linux@alteeve.com>)
List pgsql-general
Madison Kelly wrote:
> Hi all,
>
>   What is the proper syntax/escape character when using 'ALTER ... OWNER TO
> user-name'? I've tried single quotes, backslashes, backticks and various
> others without luck. Is it at all possible?

Double quotes (same as for any identifier)

--
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"Find a bug in a program, and fix it, and the program will work today.
Show the program how to find and fix a bug, and the program
will work forever" (Oliver Silfridge)

pgsql-general by date:

Previous
From: Madison Kelly
Date:
Subject: ALTER syntax question and usernames with hyphens
Next
From: Ron Mayer
Date:
Subject: Re: Primary Key