PostgreSQL is a database management system allowing custom types, triggers and table inheritance.

PostgreSQL Services in CSCF

CSCF operates three principal database clusters:

Access to CSCF database clusters is restricted to on-campus.

For information on personal database set up, see PostgresPersonalDatabases.


For Ubuntu one should become the user postgres and then run psql, the command line tool to access PostgreSQL. If one becomes the Unix user postgres, or if one uses sudo
sudo -u postgres psql

which results in the command line prompt:

Welcome to psql 8.2.4, the !PostgreSQL interactive terminal.

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

postgres=# \l
        List of databases
   Name    |  Owner   | Encoding 
 postgres  | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8
(3 rows)



See PostgreSQLSetup.


Other DBMS's varying in their scope of application, licensing etc. are MySQL, DB2, Oracle, Apache Derby. See comparison of systems on Wikipedia,


Edit | Attach | Watch | Print version | History: r13 < r12 < r11 < r10 < r9 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r13 - 2016-12-05 - DanielAllen
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback