Re: ALTER syntax question and usernames with hyphens

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Madison Kelly <linux(at)alteeve(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ALTER syntax question and usernames with hyphens
Date: 2007-11-26 20:08:35
Message-ID: 20071126200835.GB22964@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2007-11-26 20:39:13 Re: replication in Postgres
Previous Message Madison Kelly 2007-11-26 20:04:01 ALTER syntax question and usernames with hyphens