Re: Usernames with hyphens - Mailing list pgsql-hackers

From Michael Glaesemann
Subject Re: Usernames with hyphens
Date
Msg-id 16D03D54-375C-4E2E-A504-B88F7FD4B2FF@myrealbox.com
Whole thread Raw
In response to Usernames with hyphens  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Usernames with hyphens
Next
From: Devrim GUNDUZ
Date:
Subject: Re: Usernames with hyphens