pg_attrdef

The pg_attrdef table in the pg_catalog schema stores column default values. The main information about columns is stored in pg_attribute. Only columns that explicitly specify a default value (when the table is created or the column is added) will have an entry here.

column	type	references	description
`oid`	oid		The object ID
`adrelid`	oid	`pg_class.oid`	The table this column belongs to
`adnum`	smallint	`pg_attribute.attnum`	The number of the column
`adbin`	pg_node_tree		The internal representation of the column default value

Support

Resources

Contribution

Working with Git & GitHub

Contribution Overview

Code Contribution

Doc Contribution

Apache Cloudberry is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Apache®, the names of Apache projects, and the feather logo are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries.