pg_field_name - PHP code example

The php Function pg_field_name()

The php function pg_field_name() is used to retrieve the field (column) name of a given row in a PostgreSQL result. It is also used by the pg_fetch_row() member function to return a value from a given row in a table row. The function also provides field name information to pg_fetch_array(), which returns an associative array of column names and values that are numerically indexed and associated.

The size of the data sent to the server, in bytes. Used by pg_lo_seek() and pg_result_status().

Currently only supported by the PG 9.2 C client.

EXPERIMENTAL. The function and its documentation may change without notice in a future version of PHP. Use at your own risk.

A string indicating the PostgreSQL field type of a given field in a result instance (returned by pg_query(), pg_query_params() or pg_execute()). This function used to be called pg_fieldtype().

An int representing the row number of the PostgreSQL query result to fetch, if known. Otherwise, the next available row is fetched.

An indication of the context in which an error occurred. Currently, this includes a call stack traceback of active procedural language functions and internally-generated queries, but it might be extended in the future. The cursor position in the original statement text where the error occurred. This is useful for debugging. Whether the error was a fatal or nonfatal.

pg_field_name example

$a['error'][$k] = pg_result_error_field($result, $v);
            }
        }

        $a['affected rows'] = pg_affected_rows($result);
        $a['last OID'] = pg_last_oid($result);

        $fields = pg_num_fields($result);

        for ($i = 0; $i < $fields; ++$i) {
            $field = [
                'name' => pg_field_name($result, $i),
                'table' => sprintf('%s (OID: %s)', pg_field_table($result, $i), pg_field_table($result, $i, true)),
                'type' => sprintf('%s (OID: %s)', pg_field_type($result, $i), pg_field_type_oid($result, $i)),
                'nullable' => (bool) pg_field_is_null($result, $i),
                'storage' => pg_field_size($result, $i).' bytes',
                'display' => pg_field_prtlen($result, $i).' chars',
            ];
            if (' (OID: )' === $field['table']) {
                $field['table'] = null;
            }
            if ('-1 bytes' === $field['storage']) {
                $field['storage'] = 'variable size';
            }

return pg_num_fields($this->resultID);
    }

    /** * Generates an array of column names in the result set. */
    public function getFieldNames(): array
    {
        $fieldNames = [];

        for ($i = 0, $c = $this->getFieldCount(); $i < $c; $i++) {
            $fieldNames[] = pg_field_name($this->resultID, $i);
        }

        return $fieldNames;
    }

    /** * Generates an array of objects representing field meta-data. */
    public function getFieldData(): array
    {
        $retVal = [];