Re: BUG #14727: Inicial running of Postgres.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rthomques(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14727: Inicial running of Postgres.
Date: 2017-07-02 19:39:31
Message-ID: 26900.1499024371@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

rthomques(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2017-07-03 02:58:53 Re: [HACKERS] Segmentation fault in libpq
Previous Message Andres Freund 2017-07-02 19:12:22 Re: [HACKERS] Segmentation fault in libpq