| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ID column naming convention |
| Date: | 2015-10-14 08:49:45 |
| Message-ID: | 20151014084944.GA2522@hermes.hilbert.loc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ramesh T | 2015-10-14 13:38:26 | postgres function |
| Previous Message | dinesh kumar | 2015-10-14 01:50:30 | Re: Creating Report for PieChart |