BUG #14727: Inicial running of Postgres.

Started by Nonamealmost 9 years ago2 messagesbugs
Jump to latest
#1Noname
rthomques@gmail.com

The following bug has been logged on the website:

Bug reference: 14727
Logged by: Roberto Henriques
Email address: rthomques@gmail.com
PostgreSQL version: 9.6.3
Operating system: MAC OS 10.11..6
Description:

After installing Postgres and running the command in Terminal to be able to
use the path command (psql),
I got this prompt:

ast login: Sun Jul 2 15:27:56 on ttys000
roberto-henriquess-macbook-2:~ thom$ psql
psql (9.6.3)
Type "help" for help.

thom=# createdb mydb
thom-# mydb
thom-#

The prompt remains in my user name.

Thank for any help.

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: BUG #14727: Inicial running of Postgres.

rthomques@gmail.com writes:

I got this prompt:

ast login: Sun Jul 2 15:27:56 on ttys000
roberto-henriquess-macbook-2:~ thom$ psql
psql (9.6.3)
Type "help" for help.

thom=# createdb mydb
thom-# mydb
thom-#

The prompt remains in my user name.

"createdb" is a shell command; you'd issue that to your shell not to psql.
The equivalent thing to do in psql would be

create database mydb;

(don't forget the semicolon). Also, once you'd created it, the
way to switch to it within a psql session would be

\c mydb

While we're here, notice the subtle changes in psql's command prompt
--- that indicates that it thinks you're continuing a multiline command.
That's why nothing seems to be happening.  If you'd typed a semicolon
to end the command, you'd have gotten a syntax error of one sort or
another.

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs