Re: Moving from MySQL

From: Kevin Waterson <kevin(at)oceania(dot)net>
To: "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Moving from MySQL
Date: 2003-01-13 20:01:09
Message-ID: 20030114070109.28bb5619.kevin@oceania.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

This one time, at band camp,
"Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk> wrote:

> Assuming you are now the postgres user:
> createdb kevin
> you can invoke user kevin with any db as well
> psql -U kevin -d template1
> Note: If you want kevin to have all rights to the database kevin you'll have
> to make him the owner some how (eg create Kevin with createdb rights, create
> the database as Kevin, then remove the rights in psql (as postgres) alter
> user kevin nocreatedb).

This worked a treat...

Thank you, and others who replied for your time, I am sure I will have more
questions in future.

Kind regards
Kevin

--
Please avoid sending me Word or PowerPoint attachments.
See http://www.fsf.org/philosophy/no-word-attachments.html
Kevin Waterson
Port Macquarie, Australia

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message J Greenbaum 2003-01-13 20:14:40 assigning values to array elements
Previous Message Ville Jungman 2003-01-13 17:58:41 Re: Reference to multiple cols