Database Management Systems

PostgreSQL

What is PostgreSQL?

PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere.

What platforms is PostgreSQL installed on?

PostgreSQL is available on all lab-supported UNIX-based workstations. Users wishing to use PostgreSQL should request access using the form at http://www-auth.cs.wisc.edu.

See Also:

• PostgreSQL web site
• CSL PostgreSQL Database Service

SYBASE SQL Server And Tools On Computer Systems Lab Workstations

What is Sybase?

Sybase is a relational database system. Our installation includes an SQL server, various applications for submitting adhoc queries, C library routines to access the server, application and report development tools, and other useful utilities.

Support

The lab provides one installation for instructional use. Instructional support is limited to the SQL server and the isql utility for adhoc query processing. See Using The CS General Purpose Sybase SQL Server UWCS for more information on this server.

The lab will install an SQL server for faculty-sponsored research projects on research workstations, but will not administer databases. See Using The CS General Purpose Sybase SQL Server UWCS for additional information that pertains to the UWCS and other research SQL servers.

Supported Versions

Documentation

• How Do I Set Up My Environment To Use Sybase? Instructions for configuring your UNIX environment to access Sybase.
• Brief Command Syntax For Sybase Not nearly as detailed as SyBooks (syntax and brief notes, not whole manual page), but a lot quicker. Good enough for quick reference. Please note that is comes from an older version of Sybase. If you want syntax for the current version, who'll need to use Sybooks.

More Sybase Information