PG_FIELD_TYPE(3) PG_FIELD_TYPE(3)
pg_field_type - Returns the type name for the corresponding field number
SYNOPSIS
string pg_field_type (resource $result, int $field_number)
DESCRIPTION
pg_field_type(3) returns a string containing the base type name of the given $field_number in the given PostgreSQL $result resource.
Note
If the field uses a PostgreSQL domain (rather than a basic type), it is the name of the domain's underlying type that is returned,
rather than the name of the domain itself.
Note
This function used to be called pg_fieldtype(3).
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
o $field_number
- Field number, starting from 0.
RETURN VALUES
A string containing the base name of the field's type, or FALSE on error.
EXAMPLES
Example #1
Getting information about fields
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
// Assume 'title' is a varchar type
$res = pg_query($dbconn, "select title from authors where author = 'Orwell'");
echo "Title field type: ", pg_field_type($res, 0);
?>
The above example will output:
Title field type: varchar
SEE ALSO
pg_field_prtlen(3), pg_field_name(3), pg_field_type_oid(3).
PHP Documentation Group PG_FIELD_TYPE(3)
