Exercise 1 - Courseweb

needmoreneedmoreData Management

Nov 28, 2012 (4 years and 11 months ago)

228 views

CS 95 Advanced Database Systems Lab A/B


----------------------------------------------------------------------------------------

Exercise 1. Familiarization with PostgreSQL

---------------------------------------------------------------------------------
-------


1.

Access the PostgreSQL Web site at
http://www.postgresql.org

and read
the interactive documentation at
http://www.postgresql.org/idocs/

especially the “Tut
orial” and the “User’s Guide” section:


A.

What is PostgreSQL?

B.

Briefly describe its features/functionality.

C.

Compare and contrast PostgreSQL with Interbase.


2.

Do a telnet login to appserver.cs.xu.edu.ph and run the interactive PostgreSQL
command line client (b
y typing ‘psql’ at the Linux/Unix prompt). If you get an error
message type ‘psql

U postgres’ instead. Familiarize with the command line interface
and issue some queries on the system catalog (i.e., pg_* relations):


A.

What is the difference between ‘
\
h’ a
nd ‘
\
?’ Commands?

B.

What are the results if you execute the following SELECT statements:

SELECT * from pg_database;

SELECT * from pg_user;


Submit:
2
-
4 page writeup

(be brief and concise!)

Due on:
3 December 2001