Re: "Database does not exist"... but it does exist

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: "Database does not exist"... but it does exist
Date: 2011-01-21 17:13:38
Message-ID: 20110121181338.4675bb09@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, 21 Jan 2011 12:01:40 -0500, Mike Thomsen <mikerthomsen(at)gmail(dot)com>
wrote:

...
> psql -U postgres -c "create user miket with password 'miket'"
> createdb testingdb -U postgres
> psql -U postgres -d testingdb -c "create schema testingdb authorization
> miket" psql -U postgres -d testingdb -c "grant all privileges on database
> testingdb to miket"

I guess that if you used the 1st line you weren't 'postgres' user, so the 2nd
line can't give anything unless issued the way the 1st is.

--
My way of joking is to tell the truth. That's the funniest joke in the world.
-- Muhammad Ali

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike Thomsen 2011-01-21 17:38:58 Re: "Database does not exist"... but it does exist
Previous Message Thom Brown 2011-01-21 17:09:53 Re: "Database does not exist"... but it does exist