Re: How to discover foreign keys (without pulling hair out)

Hi,

I use pgAdminII on Windows. It connects to a PostgreSQL
on a Linux PC.
When you click on an existing table's icon, it shows you
a script that could have created it (it detects the
structure of the table by itself), including the foreign
keys.
That's an easy way. But maybe not very elegant...

-- Table: slip
CREATE TABLE "slip" ( "id_slip" int4 DEFAULT nextval
('"slip_id_slip_seq"'::text) NOT NULL, "proprio" int4, CONSTRAINT "slip_pkey" PRIMARY KEY ("id_slip"), CONSTRAINT
"slip_de"FOREIGN KEY ("proprio") 
REFERENCES "maitre" ("maitre_id") ON DELETE NO ACTION ON
UPDATE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE
);
COMMENT ON TABLE "slip" IS 'les slobards en folie !';
-------------------
Vous aussi devenez le "Coup de coeur de Julie" et gagnez une Webcam
sur http://www.chez.com !
Chez.com vous invite � d�couvrir l'univers passionnant des sites persos.