relation between tables

From: Mauricio Siqueira de Oliveira <mauricio(dot)oliveiraa(at)uol(dot)com(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: relation between tables
Date: 2005-03-28 23:30:54
Message-ID: 424893AE.8060605@uol.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

Is there any command to display relations between tables? Like, for
instance, I would like to know what column in what table is linked with
a particular column in other table. I´m working on a database not so
well organized and to make my queries I have to "SELECT * FROM" every
single table to see if it is linked with the one I´m working with, which
is a hell of a work!

Thanks in advance,

Mauricio

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-03-29 00:50:19 Re: relation between tables
Previous Message Bruce Momjian 2005-03-28 22:36:49 Re: initial password