Re: ID column naming convention - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: ID column naming convention
Date
Msg-id 20151014084944.GA2522@hermes.hilbert.loc
Whole thread Raw
In response to Re: ID column naming convention  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On Tue, Oct 13, 2015 at 03:44:15PM -0700, John R Pierce wrote:

> On 10/13/2015 3:27 PM, droberts wrote:
> >Thanks.   My only question is how do you create a schema diagram (ERD) then?
> >The tool won't know what the relationships are unless maybe you put foreign
> >key constraints on.  BTW does anyone recommend a tool to to that?  I've been
> >playing with DbVisualizer.
>
>
> I don't know of any ERD tool that will recognize foreign key references
> without FK constraint definitions, regardless of what things are named.

Also, there wouldn't be anything to recognize. Only to assume.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-general by date:

Previous
From: dinesh kumar
Date:
Subject: Re: Creating Report for PieChart
Next
From: Merlin Moncure
Date:
Subject: Re: Understanding "seq scans"