Tuples

In the relational model, a tuple is a fundamental concept that represents a single record or row in a table. In PostgreSQL, a tuple is composed of a set of attribute values, each corresponding to a specific column or field in the table. A tuple is defined as an ordered set of attribute values, meaning that each value in a tuple corresponds to a specific attribute or column in the table. The values can be of different data types, such as integers, strings, or dates, depending on the schema of the table.

For example, consider a users table with columns id, name, and email. A sample tuple in this table could be (1, 'John Smith', '[email protected]'), where each value corresponds to its respective column. PostgreSQL provides a variety of operations that can be performed on tuples.

Learn more from the following resources:

• @article@How PostgreSQL Freezes Tuples
• @article@Whats the difference between and tuple and a row?