By Tobi Praise Obanisola


2019-11-08 14:52:39 8 Comments

I have a postgresql db file, I just updated a table and the command prompt changed from => to (>.

What does this mean?

teamwork=> CREATE TABLE posts ( postId SERIAL PRIMARY KEY, createdOn CURRENT_TIMESTAMP, userID SERIAL REFERENCES users (userId), title VARCHAR(30) NOT NULL, article VARCHAR, imageUrl VARCHAR;
teamwork(>

1 comments

@Will Hartung 2019-11-08 14:55:24

It means that you have an unbalanced parentheses.

 teamwork=> CREATE TABLE posts ( postId SERIAL PRIMARY KEY, createdOn
 CURRENT_TIMESTAMP, userID SERIAL REFERENCES users (userId), title
 VARCHAR(30) NOT NULL, article VARCHAR, imageUrl VARCHAR; 
 teamwork(>

Notice the ( after posts is not closed before the ; at the end.

@Tobi Praise Obanisola 2019-11-08 15:03:00

Oh wow. Thank you Will. I have corrected the statement, but still showing the <). How do I remove it?

@jjanes 2019-11-08 16:00:59

You have to break out of the command it is trying to finish reading. You can enter \r<return> to clear the buffer, or hit ctrl-C to do the roughly the same thing. Or you can finish typing the command by entering );<return>, after which you will get a syntax error but will start over at a clean prompt.

Related Questions

Sponsored Content

15 Answered Questions

[SOLVED] How to change PostgreSQL user password?

19 Answered Questions

[SOLVED] Creating a copy of a database in PostgreSQL

  • 2009-05-18 07:00:17
  • egaga
  • 320304 View
  • 687 Score
  • 19 Answer
  • Tags:   postgresql

18 Answered Questions

[SOLVED] psql: FATAL: database "<user>" does not exist

  • 2013-07-13 19:18:24
  • Ryan Rich
  • 297446 View
  • 637 Score
  • 18 Answer
  • Tags:   postgresql psql

14 Answered Questions

[SOLVED] Which version of PostgreSQL am I running?

  • 2012-12-05 22:34:16
  • Highly Irregular
  • 743053 View
  • 946 Score
  • 14 Answer
  • Tags:   postgresql

22 Answered Questions

[SOLVED] How can I drop all the tables in a PostgreSQL database?

  • 2010-07-24 23:24:05
  • AP257
  • 588888 View
  • 920 Score
  • 22 Answer
  • Tags:   postgresql

21 Answered Questions

[SOLVED] Show tables in PostgreSQL

  • 2009-04-20 19:07:39
  • flybywire
  • 1755591 View
  • 1688 Score
  • 21 Answer
  • Tags:   postgresql

8 Answered Questions

[SOLVED] How to exit from PostgreSQL command line utility: psql

11 Answered Questions

[SOLVED] Run a PostgreSQL .sql file using command line arguments

23 Answered Questions

[SOLVED] List columns with indexes in PostgreSQL

19 Answered Questions

[SOLVED] PostgreSQL "DESCRIBE TABLE"

Sponsored Content