Re: Usernames with hyphens

On Jun 13, 2005, at 8:30 PM, Devrim GUNDUZ wrote:

> AFAIK, PostgreSQL does not allow hyphens in usernames and
> databases, right?

AFAIK, you can use whatever you want if you double-quote it.

test=# create database "hyphen-test";
LOG: transaction ID wrap limit is 2147484134, limited by database
"test"
CREATE DATABASE
test=# \c hyphen-test
You are now connected to database "hyphen-test".

Note that this is the SQL command, rather than another command such
as the createdb or createuser client apps or psql. For example, \c
works without the quotes.

Michael Glaesemann
grzm myrealbox com