To use PostgresQL:

  • SEE COURSE EMAIL ARCHIVE FOR ADDENDUM!
  • Log into an undergraduate instructional linux machine (e.g. sumatra).
  • Setup your environment: 
    ( in csh/tcsh )

  setenv PATH ${PATH}:/uns/pgsql/bin
  setenv LD_LIBRARY_PATH /uns/pgsql/lib
    This is where your database will be created: 
      setenv PGDATA ~/databases
  • Initialize your database directory: 
      initdb -l /uns/pgsql/lib/
  • Start the server: 
      postmaster &
  • Create your database: 
      createdb cse544
  • Start the UI: 
      psql -d cse544

    You are now in a SQL frontend to PostgresQL, you can create your tables (by pasting in this file - notice it is different from the one used for SQL Server) and enter your queries.

    More documentation can be found at http://www.postgresql.org/, along with the source code. Notice that you need a ';' (semicolon) after each line in order for it to be processed.