Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7891E476D05
	for <pgsql-docs@postgresql.org>; Mon,  9 Sep 2002 11:38:16 -0400 (EDT)
Received: from squire.barchord.com (squire.barchord.com [216.194.67.18])
	by postgresql.org (Postfix) with ESMTP id 82D66476621
	for <pgsql-docs@postgresql.org>; Mon,  9 Sep 2002 11:21:57 -0400 (EDT)
Received: from [10.0.2.147] (nat.inquent.com [216.6.14.45])
	by squire.barchord.com (Postfix) with ESMTP
	id D7727415; Mon,  9 Sep 2002 11:21:41 -0400 (EDT)
Subject: Re: pgsql user creation query:
From: Rod Taylor <rbt@rbt.ca>
To: news <da@da.com>
Cc: pgsql-docs@postgresql.org
In-Reply-To: <cdPd9.18772$Dr5.77332@news-server.bigpond.net.au>
References: <cdPd9.18772$Dr5.77332@news-server.bigpond.net.au>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 09 Sep 2002 11:21:50 -0400
Message-Id: <1031584910.268.36.camel@jester>
Mime-Version: 1.0
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/25
X-Sequence-Number: 1477

In 7.2 you must create the database as the user.
CREATE USER <user> CREATEDB;
\c - <user>
CREATE DATABASE <db>;
ALTER USER <user> NOCREATEDB;

In 7.3 you can:
CREATE DATABASE <db> WITH OWNER = <user>;

On Thu, 2002-09-05 at 16:34, news wrote:
> Hi all,
> 
> I'm just starting out with pgsql, moving away from mysql as I'm missing
> having a procedural language. Anyway, I apologise if this is an easily
> resolved problem, I have looked through the docs for any answers but they
> don't seem to be coming easily.
> 
> I'm wondering if it's possible to create a user and assign that user as an
> owner of a database, so that user can do pretty much anything they wish to
> that database and any existing and to-be-created objects within it?
> 
> I hope this makes sense
> Thank you all for your time,
> Michael.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 
-- 
  Rod Taylor