Query: pg_field_table
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
PG_FIELD_TABLE(3) PG_FIELD_TABLE(3) pg_field_table - Returns the name or oid of the tables fieldSYNOPSISmixed pg_field_table (resource $result, int $field_number, [bool $oid_only = false])DESCRIPTIONpg_field_table(3) returns the name of the table that field belongs to, or the table's oid if $oid_only is TRUE.PARAMETERSo $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. o $oid_only - By default the tables name that field belongs to is returned but if $oid_only is set to TRUE, then the oid will instead be returned.RETURN VALUESOn success either the fields table name or oid. Or, FALSE on failure.EXAMPLESExample #1 Getting table information about a field <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); $res = pg_query($dbconn, "SELECT bar FROM foo"); echo pg_field_table($res, 0); echo pg_field_table($res, 0, true); $res = pg_query($dbconn, "SELECT version()"); var_dump(pg_field_table($res, 0)); ?> The above example will output something similar to: foo 14379580 bool(false)NOTESNote Returning the oid is much faster than returning the table name because fetching the table name requires a query to the database system table.SEE ALSOpg_field_name(3), pg_field_type(3). PHP Documentation Group PG_FIELD_TABLE(3)
Related Man Pages |
---|
pg_field_num(3) - php |
pg_cancel_query(3) - php |
pg_field_prtlen(3) - php |
pg_field_type(3) - php |
pg_last_oid(3) - php |
Similar Topics in the Unix Linux Community |
---|
Unix scripting pl help |
Deduplicate fields |
Partition Resize / Creation |
Check a field in a table |