Re: Relationships

> How do I create relationships in PgSQL or in PgAdmin?

Same way in most SQL-based databases: through the DDL statements such as
CREATE TABLE or ALTER TABLE.

For example

CREATE TABLE PARENT (ID INT PRIMARY KEY, LNAME TEXT);
CREATE TABLE CHILD (PID INT REFERENCES PARENT, LNAME TEXT);

will "create a relationship" between the parent and child tables.
(If you're coming from a background in Access or something similar,
this creates a relationship
with "referential integrity" but without any cascades--PG supports
cascading; see CREATE TABLE man for details)

--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington