This directory contains SQL tutorial scripts. To look at them, first do a
% make
to compile all the scripts and C files for the user-defined functions
-and types. (make needs to be GNU make and may be named something
-different on your system)
+and types. (make needs to be GNU make --- it may be named something
+different on your system, often gmake)
-Then, run psql with the -s flag:
+Then, run psql with the -s (single-step) flag:
% psql -s
-Welcome to the POSTGRESQL interactive sql monitor:
- Please read the file COPYRIGHT for copyright terms of POSTGRESQL
-
- type \? for help on slash commands
- type \q to quit
- type \g or terminate with semicolon to execute query
- You are currently connected to the database: jolly
-
-jolly==>
-
From within psql, you can try each individual script file by using
-the \i <filename> psql command.
-
+psql's \i <filename> command.