Skip site navigation (1) Skip section navigation (2)

Re: pgsql user creation query:

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: news <da(at)da(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: pgsql user creation query:
Date: 2002-09-09 15:21:50
Message-ID: 1031584910.268.36.camel@jester (view raw or flat)
Thread:
Lists: pgsql-docs
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


In response to

pgsql-docs by date

Next:From: Rod TaylorDate: 2002-09-09 18:39:05
Subject: Re: RESTRICT / CASCADE
Previous:From: Rod TaylorDate: 2002-09-07 19:30:50
Subject: RESTRICT / CASCADE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group