class pq\Gateway\Table\Attributes implements IteratorAggregate

The table attributes (columns) of a table.

Query:

The following query is executed by the current executor of the table to retrieve the table attributes:

select 
     attnum         as index
    ,attname        as name
    ,atttypid       as type
    ,atthasdef      as hasdefault
    ,not attnotnull as nullable
from
     pg_attribute 
where attrelid = \$1::regclass 
and   attnum   > 0

Cache:

The result of this query is cached in the metadata cache under the following key, where $table is converted to a string by pq\Gateway\Table::__toString():

"$table:attributes"

Properties:

Functions: