Every user has own database - how?

From: "Jaro" <jaro80(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Every user has own database - how?
Date: 2007-03-23 00:01:20
Message-ID: 1174608080.384872.316840@n76g2000hsh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

How create something like this:

UserName: user1 (he's root db_user1)
DatabaseName db_user1

UserName: user2 (he's root db_user2)
DatabaseName db_user2

I'd like create several users and several databases, ever user should
be root only for own database

Could anybody show my SQL example how do this, please. I'm new in
postgresql, I've used mysql

--
Best regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2007-03-23 00:09:26 Re: multi-row check constraints?
Previous Message Jeff Davis 2007-03-22 22:30:37 Re: making postgres DB stable, efficient and secure