July 10th, 2002, 05:00 PM
redhat linux 7.3 problem
I just installed redhat linux 7.3. During the initial installation, I had it install postgresql. After I su as postgres, I then run the command 'psql template1'. At the psql command prompt, I try to run various command, but none of them work. When I hit enter, the command line just opens up another line and my command is lost into infinity.
Any ideas why this is happening?
Nothing works. I cannot run select statements.... Nothing....
Thanks in Advance....
July 13th, 2002, 05:36 AM
The psql program can be difficult to deal with.
Are you using the backslash character before issuing each command? (\)
For example, \h will show a list of help commands.
I recommend geting an admin tool to help you get started, so you don't have to use command line:
Any good admin for pgsql beside phpPgAdmin?
July 13th, 2002, 06:21 AM
Er... you are aware that an SQL command has to end with a semicolon in order to execute, right? In fact, you can enter several lines worth of statements, and then end them all with a ";" and only then will they execute. Very useful feature, because then you can do something nice and readable like
The semicolon basically means "Got it? Go!".
lastname = 'Striker'
firstname = 'Ted'