PostgreSQL psql – not working but no errors [closed]

Posted on

Question :

I’m a complete noob to PostgreSQL, so I’m probably missing something completely obvious.

Connected to my local db via psql on terminal. Any command I run to make db changes, or even a simple select does nothing. No error, just no results.

I can use the shell commands createdb, dropdb just fine.

Got a site running in Ruby on Rails, RefineryCMS, using the local PostgreSQL db, so I know the db has data and is working – I just can’t seem to query or modify it via psql.

What am I missing?

Mac OS X Lion, pg v 9.2.

Answer :

Jumped on the IRC postgresql channel and had this answered in 30 seconds.

Issue was that I was not ending my SQL commands with a semicolon. Doh!

Leave a Reply

Your email address will not be published. Required fields are marked *