PG_LAST_OID(3)PG_LAST_OID(3)pg_last_oid - Returns the last row's OIDSYNOPSIS
string pg_last_oid (resource $result)
DESCRIPTION pg_last_oid(3) is used to retrieve the $OID assigned to an inserted row.
OID field became an optional field from PostgreSQL 7.2 and will not be present by default in PostgreSQL 8.1. When the OID field is not
present in a table, the programmer must use pg_result_status(3) to check for successful insertion.
To get the value of a SERIAL field in an inserted row, it is necessary to use the PostgreSQL CURRVAL function, naming the sequence whose
last value is required. If the name of the sequence is unknown, the pg_get_serial_sequence PostgreSQL 8.0 function is necessary.
PostgreSQL 8.1 has a function LASTVAL that returns the value of the most recently used sequence in the session. This avoids the need for
naming the sequence, table or column altogether.
Note
This function used to be called pg_getlastoid(3).
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
RETURN VALUES
A string containing the OID assigned to the most recently inserted row in the specified $connection, or FALSE on error or no available
OID.
EXAMPLES
Example #1
pg_last_oid(3) example
<?php
// Connect to the database
pg_connect("dbname=mark host=localhost");
// Create a sample table
pg_query("CREATE TABLE test (a INTEGER) WITH OIDS");
// Insert some data into it
$res = pg_query("INSERT INTO test VALUES (1)");
$oid = pg_last_oid($res);
?>
SEE ALSO pg_query(3), pg_result_status(3).
PHP Documentation Group PG_LAST_OID(3)
Check Out this Related Man Page
PG_FIELD_NAME(3)PG_FIELD_NAME(3)pg_field_name - Returns the name of a fieldSYNOPSIS
string pg_field_name (resource $result, int $field_number)
DESCRIPTION pg_field_name(3) returns the name of the field occupying the given $field_number in the given PostgreSQL $result resource. Field numbering
starts from 0.
Note
This function used to be called pg_fieldname(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
The field name, or FALSE on error.
EXAMPLES
Example #1
Getting information about fields
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
$i = pg_num_fields($res);
for ($j = 0; $j < $i; $j++) {
echo "column $j
";
$fieldname = pg_field_name($res, $j);
echo "fieldname: $fieldname
";
echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters
";
echo "storage length: " . pg_field_size($res, $j) . " bytes
";
echo "field type: " . pg_field_type($res, $j) . "
";
}
?>
The above example will output:
column 0
fieldname: author
printed length: 6 characters
storage length: -1 bytes
field type: varchar
column 1
fieldname: year
printed length: 4 characters
storage length: 2 bytes
field type: int2
column 2
fieldname: title
printed length: 24 characters
storage length: -1 bytes
field type: varchar
SEE ALSO pg_field_num(3).
PHP Documentation Group PG_FIELD_NAME(3)
Hi,
I am working on a script that inserts one row of data at the time to a table.
Among the fields of that table is the “serial” which is the auto increment. I need to be able to retrieve last inserted row id to use it for another insert.
To retrieve last row id right after I do successful... (2 Replies)
Hi,
We need ur advice,...
We are integrating our application (oracle) with OID,and OID is with another team.
While integrating they have to provide their 'ADMIN-password' when the script prompts ,But the password they are about type is visible.
If this is the case they are denying it,....
Is... (1 Reply)
Hi,
I want to test a var, $inputPin to see if is 3 digits in a row or not in a Bash script.
I am getting stuck on the regex to do this.
And the equality test if it is in an if statement as below?
-ne is for comparing numbers
But I guess it would be != in this case
if \{3,3\]}]
... (6 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)