Getting started with postgresql on Fedora Core 2

This is what you can do right after you have installed
postgreSQL on your Fedora Core 2 system with a command like:

yum install postgresql*

Step 1: Start the postgreSQL daemon.

(For GNOME use the "[RED HAT]^System Settings>Server Settings>Services"
menu item to start the Service Configuration application.  Then make sure
the [] postgresql item is checked in the list on the left side of the
Service Configuration application window.
If you had to change the item to make it checked, hit the "Save" button.

if you don't see something like:

postmaster (pid 4479 4478 4474) is running...

in the status box hit the start button while the
[] postgesql item is still highlighted.)

Step 2: Create a database for yourself.

[whomever@wherever whomever]$ su
Password:
[root@wherever whomever]# su - postgres
-bash-2.05b$ createdb test
CREATE DATABASE
-bash-2.05b$ psql test
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

test=# CREATE USER whomever;
CREATE USER

test=# CREATE DATABASE whomever;
CREATE DATABASE

test=# GRANT ALL PRIVILEGES ON DATABASE whomever TO whomever;
GRANT

test=# \q
-bash-2.05b$ exit
logout
[root@wherever whomever]# exit
exit
[whomever@wherever whomever]$ psql
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

whomever=> CREATE TABLE MY_TABLE (MY_COLUMN INTEGER);
CREATE TABLE
whomever=> INSERT INTO MY_TABLE(MY_COLUMN) VALUES(1);
INSERT 17146 1
whomever=> SELECT * FROM MY_TABLE;
my_column
-----------
         1
(1 row)

whomever=> \q
[whomever@wherever whomever]$