From oravecja@intrak.tuke.sk Wed Apr 3 15:07:15 2002 Received: from alfa.intrak.tuke.sk (alfa.intrak.tuke.sk [147.232.152.3]) by postgresql.org (Postfix) with ESMTP id 965FD47607F for ; Wed, 3 Apr 2002 10:07:15 -0500 (EST) Received: from elvin (elvin.intrak.tuke.sk [147.232.153.229]) by alfa.intrak.tuke.sk (Postfix) with SMTP id 5E97B1500D for ; Wed, 3 Apr 2002 17:07:01 +0200 (CEST) MIME-Version: 1.0 Message-Id: <3CAB1A96.000003.01336@elvin.intrak.tuke.sk> Date: Wed, 3 Apr 2002 17:07:02 +0200 (Central Europe Daylight Time) Content-Type: Multipart/related; type="multipart/alternative"; boundary="------------Boundary-00=_QBZZG6G0000000000000" X-Mailer: IncrediMail 2001 (1600532) From: "Jan Oravec" X-FID: FLAVOR00-NONE-0000-0000-000000000000 X-FVER: 2.0 X-CNT: ; X-Priority: 3 To: Subject: Primary and foreign key from system tables X-Archive-Number: 200204/30 X-Sequence-Number: 7295 --------------Boundary-00=_QBZZG6G0000000000000 Content-Type: Multipart/Alternative; boundary="------------Boundary-00=_QBZZBHK0000000000000" --------------Boundary-00=_QBZZBHK0000000000000 Content-Type: Text/Plain; charset="windows-1250" Content-Transfer-Encoding: quoted-printable I have one problem.=0D =0D How can I get from system tables references on primary and foreign key.=0D =0D Jan Oravec --------------Boundary-00=_QBZZBHK0000000000000 Content-Type: Text/HTML; charset="windows-1250" Content-Transfer-Encoding: quoted-printable =0D
I have one problem.
 
How can I get from system tables references on primary and forei= gn=20 key.
 
    Jan Oravec
 
____________________________________________________
 =20 IncrediMail - Email has finally evolved -
Click=20 Here
--------------Boundary-00=_QBZZBHK0000000000000-- --------------Boundary-00=_QBZZG6G0000000000000 Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gL////wAAAAAA AAAAAAAAAAAAAAAAAAAAACH/C05FVFNDQVBFMi4wAwEAAAAh+QQJFAAIACwA AAAAFAAPAAAEVRDJSaudJuudrxlEKI6BURlCUYyjKpgYAKSgOBSCDEuGDKgr AtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRtE30tVVRscMHD qV/u+AgAIfkEBWQACAAsAAAAABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQA IfkECRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCq K1kS9grQhXGAhsDBUJgZAL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKX dAgRAQAh+QQFCgAIACwAAAAAFAAPAAAEEhDJSau9OOvNu/9gKI5kaZ5oBAAh +QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj1g2FsKor WRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0 CBEBACH5BAVkAAgALAAAAAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= --------------Boundary-00=_QBZZG6G0000000000000-- From sszabo@megazone23.bigpanda.com Wed Apr 3 16:39:26 2002 Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id DABE6476484 for ; Wed, 3 Apr 2002 11:39:26 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 9C196D602; Wed, 3 Apr 2002 08:39:31 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 91B545BFC; Wed, 3 Apr 2002 08:39:31 -0800 (PST) Date: Wed, 3 Apr 2002 08:39:31 -0800 (PST) From: Stephan Szabo To: Jan Oravec Cc: Subject: Re: Primary and foreign key from system tables In-Reply-To: <3CAB1A96.000003.01336@elvin.intrak.tuke.sk> Message-ID: <20020403083804.Y92483-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/32 X-Sequence-Number: 7297 On Wed, 3 Apr 2002, Jan Oravec wrote: > I have one problem. > > How can I get from system tables references on primary and foreign > key. For foreign keys you can check out information on techdocs.postgresql.org in the technical guides section, there's a couple of articles on the foreign key system.