Postgres Pro
Downloads
Home   >   mailing lists

Thread: Need clarification on "field"

Need clarification on "field"

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/limits.html
Description:

Under page "https://www.postgresql.org/docs/current/limits.html", below
limitations are mentioned:

field size - 1 GB
identifier length - 63 bytes

I understand "identifier" as the name we provide for tables, columns etc.

By the way, what is "field" in Postgresql? I don't see any official
page/explanation for this.

Re: Need clarification on "field"

From
Laurenz Albe
Date:
On Tue, 2024-06-04 at 19:54 +0000, PG Doc comments form wrote:
> Under page "https://www.postgresql.org/docs/current/limits.html", below
> limitations are mentioned:
>
> field size - 1 GB
> identifier length - 63 bytes
>
> I understand "identifier" as the name we provide for tables, columns etc.
>
> By the way, what is "field" in Postgresql? I don't see any official
> page/explanation for this.

The PostgreSQL term would be "attribute".  Perhaps we should use that.
Alternatively, what about "column value"?  It is perhaps not accurate,
because a Datum need not be stored in a column, but it might be readily
understandable.

Yours,
Laurenz Albe

Re: Need clarification on "field"

From
Bruce Momjian
Date:
On Wed, Jun  5, 2024 at 12:15:45PM +0200, Laurenz Albe wrote:
> On Tue, 2024-06-04 at 19:54 +0000, PG Doc comments form wrote:
> > Under page "https://www.postgresql.org/docs/current/limits.html", below
> > limitations are mentioned:
> > 
> > field size - 1 GB
> > identifier length - 63 bytes
> > 
> > I understand "identifier" as the name we provide for tables, columns etc.
> > 
> > By the way, what is "field" in Postgresql? I don't see any official
> > page/explanation for this.
> 
> The PostgreSQL term would be "attribute".  Perhaps we should use that.
> Alternatively, what about "column value"?  It is perhaps not accurate,
> because a Datum need not be stored in a column, but it might be readily
> understandable.

The way I understand it, we have rows and columns, and each "cell" is a
field.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.