PG_FIELD_TABLE(3)PG_FIELD_TABLE(3)pg_field_table - Returns the name or oid of the tables fieldSYNOPSIS
mixed pg_field_table (resource $result, int $field_number, [bool $oid_only = false])
DESCRIPTION pg_field_table(3) returns the name of the table that field belongs to, or the table's oid if $oid_only is TRUE.
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.
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 VALUES
On success either the fields table name or oid. Or, FALSE on failure.
EXAMPLES
Example #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)
NOTES
Note
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 ALSO pg_field_name(3), pg_field_type(3).
PHP Documentation Group PG_FIELD_TABLE(3)
Check Out this Related Man Page
PG_FIELD_TYPE(3)PG_FIELD_TYPE(3)pg_field_type - Returns the type name for the corresponding field numberSYNOPSIS
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)
Hi All,
I am new to Unix Scripting. I have below scenario. I need to write a Unix function with the following.
1. I have table. From this table I need to write a query.
SELECT Col1(File_nm),Col2(From_Loc),Col3(To_Loc)
FROM A
WHERE CONDITION
For... (1 Reply)
Hi All,
I have a file which has the conetent like this:-
SELECT F1, F2, F3, F1, F5, F2 FROM T1
I Want to replace multiple occurences of F1 and F2 with single field.
Required Output Should be:
SELECT F1, F2, F3,F5 FROM T1
Please guide me how can i do this?
Thanks in Advance.
Dilip (1 Reply)
Hello,
I'm new to SCO and I require some help...
I have an OLD HD which is about to die and I want to replace it with a new HD.
When I clone the HD with either Acronis or Ghost it wont allow me to resize the UNIX partition and I'm stuck with 80% of the new drive as unused space.
I... (7 Replies)
I have made a table PRD_WORK_LM.test and it contains one field, ctrl_test. This field contains a 0 or a 1. I want to write a unix script that goes like this:
IF ctrl_test = 1 THEN ... ELSE exit FI
How can I write this in a script? Do I have to do this within bteq? or outside bteq? can... (5 Replies)