Build A Celestial Bodies Database - Terminal returns nothing after entering a INSERT INTO

When there are syntax errors in the use of apostrophes, the terminal will become:
instead of:

The psql terminal in use will return nothing and some lines of code before the piece of problematic code would not be able to save too.

Does anybody know how to navigate back to “universe=>”?

Soooo it seems like the terminal thought I was adding comments.

For those who experience the same issue, the below works:
universe’> ’
universe(> )
universe-> press the upward button to use the last SQL code
and it will be back to “universe=>”

1 Like

There some more details here @Avocadora. You can also use crtl+c to reset the prompt.


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.