Exercise 1 - Courseweb

needmoreneedmoreΔιαχείριση Δεδομένων

28 Νοε 2012 (πριν από 4 χρόνια και 10 μήνες)

225 εμφανίσεις

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