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!