Horton
Menu

Re: Does included columns part of the PK

Adrian Klaver <adrian.klaver@aklaver.com>

View thread
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Igor Korot <ikorot01@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2026-03-15T15:34:13Z
Lists: pgsql-general 
On 3/14/26 11:24 PM, Igor Korot wrote:
> Hi, Adrian,

> 
> Lets start with the beginning:
> 
> draft=# CREATE TABLE leagues_new(id serial, name varchar(100),
> drafttype smallint, scoringtype smallint, roundvalues smallint,
> leaguetype char(5), salary integer, benchplayers smallint, primary
> key(id) INCLUDE (drafttype, scoringtype) WITH( fillfactor = 50,
> deduplicate_items = OFF ));
> CREATE TABLE
> draft=#

I think the above is for this thread:

https://www.postgresql.org/message-id/CA%2BFnnTyGEM-1mwxKPbwFTOodf%2BYUX%3DTxTmBPY5S%3DYh1h%3DoVY9A%40mail.gmail.com




-- 
Adrian Klaver
adrian.klaver@aklaver.com