Folks
As I have been unable to install pgadmin3 on my OpenSUSE Linux 10 box (erroneously described as 11.2 in the request for help post, that was useless), I have decided to use psql since it seems to be my only option.
However, I have no database as yet, and when I type in a console 'psql' I get the message "psql: FATAL: database 'username' does not exist"
So I try to start by sending the createdb command, as in: "psql -c createdb -T DEFAULT 'timecard'" but this returns the error "psql: FATAL: database "timecard" does not exist"
I tried using the database 'postgres' which seems to be created during the install:
psql postgres, which takes me to a psql prompt. However, the command createdb -T DEFAULT "timecard" now results in the error "syntax error at or neat "createdb" with a carat pointing to the 'c' in 'createdb'.
As usual, stuck again!
Any ideas greatly appreciated.
Fred