relationship in a table

From: "Kai Schlamp" <stroncococcus(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: relationship in a table
Date: 2007-01-25 16:46:35
Message-ID: 1169743595.400048.166680@a75g2000cwd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

What is the best way to find out the relationship of two columns in a
table?
I want to know if it is 1:1, 1:N, or M:N. Is there an easy way to do
this with a SQL statement?

Best regards,
Kai

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-01-25 16:52:37 Re: Problem with result ordering
Previous Message Tom Lane 2007-01-25 16:43:36 Re: Problem with result ordering