-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 13 Jun 2005, Weilguni Mario wrote:
In fakt, it allows users with hyphens, but you have to use quotes:
CREATE USER "foo-bar";
DROP USER "foo-bar";
Yeah quotes. I should have remembered it. Thanks Weilgunu, Dave and
Michael.
Regards
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
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Devrim GUNDUZ
> Sent: 13 June 2005 12:31
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] Usernames with hyphens
>
> template1=# CREATE USER hyphen-test;
> ERRO
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
AFAIK, PostgreSQL does not allow hyphens in usernames and databases,
right?
template1=# SELECT version();
version
-
--
13. Juni 2005 13:31
An: pgsql-hackers@postgresql.org
Betreff: [HACKERS] Usernames with hyphens
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
AFAIK, PostgreSQL does not allow hyphens in usernames and databases, right?
template1=# SELECT version();