Re: psql console cannot perform createdb (windows 8.1)

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: psql console cannot perform createdb (windows 8.1)
Date: 2014-12-31 03:54:45
Message-ID: 1419998085499-5832492.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Tracy Bunch wrote
> No error messages during installation but console application can
> perform read operations (\l; select *, etc.) but will not perform write
> operations (createdb). PGadmin and the createdb console apps work
> correctly. I have tied the postgres and another user account with the
> same results.

"createdb" is a shell/command-line application and not something you run
inside of psql.

Since the "postgres" database is created for you how about you try some of
the following while logged into that database.

CREATE DATABASE newdatabase;
CREATE TABLE testtable (id serial, content text);
INSERT INTO testtable (content) VALUES ('test content');
UPDATE testtable SET content = 'newcontent';
DELETE FROM testtable;

Also, when you say "will not perform" - it has to be telling you something
when you attempt to run something. You should provide exactly what it is
you tried to run and the exact response that you were given.

David J.

--
View this message in context: http://postgresql.nabble.com/psql-console-cannot-perform-createdb-windows-8-1-tp5832491p5832492.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ravi Kiran 2015-01-05 19:13:22 Node
Previous Message Tracy Bunch 2014-12-31 03:39:04 psql console cannot perform createdb (windows 8.1)