Sponsored Content
Full Discussion: Need help
Top Forums Shell Programming and Scripting Need help Post 302104657 by Glenn Arndt on Friday 26th of January 2007 12:03:08 PM
Old 01-26-2007
Give this a try:
Code:
integer i=0
tr '\t' ' ' < tables.* | cut -d" " -f1 | while read table; do
  i=i+1
  echo "delete from $table;"
  echo ".IF ERRORCODE <> 0 Then .QUIT $i"
done > outfile


Last edited by Glenn Arndt; 01-26-2007 at 01:03 PM.. Reason: Syntax!
 
PG_FIELD_TABLE(3)														 PG_FIELD_TABLE(3)

pg_field_table - Returns the name or oid of the tables field

SYNOPSIS
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)
All times are GMT -4. The time now is 03:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy