Postgres Pro
Downloads
Home   >   mailing lists

r there downsides to explicitly naming a pk column xxxx_pk - Mailing list pgsql-novice

From john snow
Subject r there downsides to explicitly naming a pk column xxxx_pk
Date
Msg-id CAE67tvU8C+jZWysXXScH4KQD6tkdy2pLOfKiMb-B4SZnfhqpLQ@mail.gmail.com
Whole thread Raw
Responses Re: r there downsides to explicitly naming a pk column xxxx_pk  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view
instead of the more conventional xxxx_id or just id?

sorry if this may be a foolish question to some, but i'm trying to think thru
a junior colleagues's proposal. the discussion occurred while we were
discussing naming our foreign key constraints using the convention
"childtable_parenttable_colname_fk".

thanks for any guidance!

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: copy from csv and postgresql 10's new identity column type
Next
From: "David G. Johnston"
Date:
Subject: Re: r there downsides to explicitly naming a pk column xxxx_pk