These are the instructions on how to access PostgreSQL database.


ACCOUNT and PASSWORDS

Your account name and passwords are the same as your Oracle
account name and *original* Oracle password given to you in
the class.

You should note that a change of Oracle password does not imply
a change in your PostgreSQL password and vice versa. These are
independently controlled with only initial values being equal.



ENVIROMENT VARIABLES

It is essential that you set the following unix shell Enviroment 
Variables:

	PGDATA     = /home/fcmsc424sc/sc42405/pgsql/data
	PGDATABASE = put-here-oracle-login-name
	PGUSER     = put-here-oracle-login-name
	PGHOST     = marlowe

Depending on what shell you use, you will set these variables
in different ways.

Additionally you should add 

	/home/fcmsc424sc/sc42405/pgsql/bin

to your PATH environment variable, and

	/home/fcmsc424sc/sc42405/pgsql/man

to your MANPATH variable (MANPATH has the same structure as PATH)

Again, depending on what shell you use, you will *add* these paths
into your existing paths in different ways.

You should probably set all these variables in a login script (.login,
.cshrc, .bashrc, .bash_profile, ...).


DATABASE ACCESS


Psql is the command that you will use to access PostgreSQL server.
Psql is a client application that will try to connect to the server.
It will ask you for password, and you will use the same password
given to you for Oracle account.

Use "man psql" for more details.


EXAMPLE SESSION

If you have your database (not unix!) username sc42405, and you set 
	PGDATABASE = sc42405
	PGUSER     = sc42405
then, the following would be a sample session that list sql commands 
for which there is available help.

[marlowe pw]$ psql
Password: 
Welcome to psql, 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

sc42405=> \h
Available help:
  ABORT                     CREATE TRIGGER            GRANT                     
  ALTER GROUP               CREATE TYPE               INSERT                    
  ALTER TABLE               CREATE USER               LISTEN                    
  ALTER USER                CREATE VIEW               LOAD                      
  BEGIN                     DECLARE                   LOCK                      
  CHECKPOINT                DELETE                    MOVE                      
  CLOSE                     DROP AGGREGATE            NOTIFY                    
  CLUSTER                   DROP DATABASE             REINDEX                   
  COMMENT                   DROP FUNCTION             RESET                     
  COMMIT                    DROP GROUP                REVOKE                    
  COPY                      DROP INDEX                ROLLBACK                  
  CREATE AGGREGATE          DROP LANGUAGE             SELECT                    
  CREATE CONSTRAINT TRIGGER DROP OPERATOR             SELECT INTO               
  CREATE DATABASE           DROP RULE                 SET                       
  CREATE FUNCTION           DROP SEQUENCE             SET CONSTRAINTS           
  CREATE GROUP              DROP TABLE                SET TRANSACTION           
  CREATE INDEX              DROP TRIGGER              SHOW                      
  CREATE LANGUAGE           DROP TYPE                 TRUNCATE                  
  CREATE OPERATOR           DROP USER                 UNLISTEN                  
  CREATE RULE               DROP VIEW                 UPDATE                    
  CREATE SEQUENCE           END                       VACUUM                    
  CREATE TABLE              EXPLAIN                   
  CREATE TABLE AS           FETCH                     
sc42405=> \q
[marlowe pw]$