CREATEUSER == SUPERUSER?

From: Yoshiyuki Asaba <y-asaba(at)sraoss(dot)co(dot)jp>
To: pgsql-patches(at)postgresql(dot)org
Subject: CREATEUSER == SUPERUSER?
Date: 2006-01-09 17:04:20
Message-ID: 20060110.020420.78728593.y-asaba@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hi,

The following command makes a superuser. Is this correct?

template1=# CREATE USER xyz CREATEUSER;
CREATE ROLE
template1=# select rolname,rolsuper from pg_roles where rolname = 'xyz';
rolname | rolsuper
---------+----------
xyz | t
(1 row)

I think CREATEUSER keyword is equal to CREATEROLE.

Regards,
--
Yoshiyuki Asaba
y-asaba(at)sraoss(dot)co(dot)jp

Attachment Content-Type Size
unknown_filename text/plain 919 bytes

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2006-01-09 18:07:30 pl/python refcount bug
Previous Message Hannu Krosing 2006-01-09 15:48:21 Re: Stats collector performance improvement