I agree its old. I'm working on the upgrade but first need to verify
and then purge some data.
I tried with and without a semicolon
However, with a semicolon results in
Just tried semicolon again.. First time resulted in results. Second
time resulted in
select * from survey_results;
ERROR: parser: parse error at or near "select" at character 30.
Maybe another reason I need to upgrade?
Tom Lane wrote:
John Mulkerin <[EMAIL PROTECTED]> writes:
I'm new to Postgres. I'm trying to select data from my survey_results
table. My server is running Postgres 7.3.4.
Do you realize how ancient that version is? An update would be a
real good idea.
I log in as root (its RH), then
psql database_name. Its says "Welcome..... ". I then type "SELECT *
from survey_results" and hit enter. Nothing! It just goes back to the
database_name prompt.
It sounds like you've forgotten to end the command with a semicolon.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
