Re: Intermittent Empty return

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 <jmulkerin(at)comcast(dot)net> 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
>
>