Thread: ALTER syntax question and usernames with hyphens

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?

Thanks!

Madi

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)