Re: created databases as other users... - Mailing list pgsql-general

Jonathan Villa <jvilla@innovativesource.net> writes:
> $ createdb --owner=testcon testdb
> but the owner ends up being postgres

I don't think so.

$ createuser testcon
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER
$ createdb --owner=testcon testdb
CREATE DATABASE
$ psql -l
        List of databases
    Name    |  Owner  | Encoding
------------+---------+-----------
 pltest     | tgl     | SQL_ASCII
 regression | tgl     | SQL_ASCII
 template0  | tgl     | SQL_ASCII
 template1  | tgl     | SQL_ASCII
 testdb     | testcon | SQL_ASCII
(5 rows)

$

            regards, tom lane