pg_execute
pg_fetch_all
PostgreSQL Funções
PHP Manual

# pg_fetch_all_columns

(PHP 5 >= 5.1.0)

pg_fetch_all_columns — Fetches all rows in a particular result column as an array

### Descrição

array pg_fetch_all_columns ( resource `$result` [, int `$column` = 0 ] )

pg_fetch_all_columns() returns an array that contains all rows (records) in a particular column of the result resource.

> Nota: Esta função assimila campos NULL para o o `NULL` do PHP.

### Parâmetros

`result`

  PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).

`column`

  Column number, zero-based, to be retrieved from the result resource. Defaults to the first column if not specified.

### Valor Retornado

An array with all values in the result column.

`FALSE` is returned if `column` is larger than the number of columns in the result, or on any other error.

### Exemplos

Exemplo #1 pg_fetch_all_columns() example

`<?php
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
echo "An error occured.\n";
exit;
}
$result = pg_query($conn, "SELECT title, name, address FROM authors");
if (!$result) {
echo "An error occured.\n";
exit;
}
// Get an array of all author names
$arr = pg_fetch_all_columns($result, 1);
var_dump($arr);
?>`

### Veja Também

- pg_fetch_all() - Retorna todas as linhas (registros) como um array

pg_execute
pg_fetch_all
PostgreSQL Funções
PHP Manual