Re: CREATE USER vs. createuser

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Mihai Gheorghiu <tanethq(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CREATE USER vs. createuser
Date: 2001-09-06 07:01:42
Message-ID: 20010906090142.B1047@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 05, 2001 at 11:57:48AM -0400, Mihai Gheorghiu wrote:
> With createuser I managed to create users like 12345 and John Doe (with a
> space).
> It did not work with CREATE USER.
> Aren't they supposed to do the same?

The createuser is a simple script and use SQL query "CREATE USER" too.

CREATE USER "John Doe";

...quotation marks is the thing that you search.

Karel
--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Withers 2001-09-06 07:15:50 problem with selects based on dates
Previous Message Oliver Elphick 2001-09-06 06:24:19 Re: FOREIGN KEY: MATCH FULL