Re: Moving from MySQL

This one time, at band camp,
"Henshall, Stuart - Design & Print" <SHenshall@westcountry-design-print.co.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