Using PostgreSQL

• First, you should have an account on cubist.  If not, please contact support@cs.washington.edu immediately.
  
  
• Log into cubist using ssh, etc.
  
  
• To interact with the database run:
  
  /usr/local/pgsql/bin/psql -U [user-name] cse544
  (I have created accounts using your u.washington.edu login-name)
  
  
• When you are prompted for your password, use cse544.
  
  
• Change your password:
  
  alter user [user-name] with encrypted password '[new-password]';
  (where [user-name] is your login name and [new-password] is your new password)
  
  
• To see the tables already defined run:
  
  \dt
  
  
• Try a simple query:
  
  SELECT * FROM names WHERE name = 'Lung';
  
  
• Or a more complicated query (these are the parts of the lung):
  
  SELECT name FROM names, parts WHERE names.id = parts.part and parts.id = 12277 and names.isSynonym = 0;
  
  
• To exit PostgreSQL, run:
  
  \q
  
  
• Congratulations, you R now a database user.