Hello ALL,
I really need help to grep data and store in particular format. I am struggling to write that script .Please help me to solve this problem otherwise i will loose my job...
I have to compare 2 files and generate the staticts of the data.
First file product.dat contains 2 column . ... (4 Replies)
hello, is there a way to seperate commands that are on the same line?
ie: echo "yes count(*)>0:" $passvar > dsp cat dsp cat dsp > log
i'm trying to put these 3 commands on the same line, but when i do they all get concatenated into 1 lieteral
if i put the cat commands on... (3 Replies)
i want to write a script in Bash Shell that accept a list of files.an example of file is
4334:234
322.345:32
234:3452 e.t.c
each file only contain lines like num1:num2
i want to count the lines of this file and find the summary of X=4334+322.345+234 and Y=234+32+3452 (1 Reply)
Dear all,
i dont know how to split one variable value in 2 variable. please send me any example.
variable1= "abcde developer"
now i want to seperate the values and seperator is space. (6 Replies)
Hi All
I have recently had to start using Unix for work and I have hit brick wall with this prob....
I have a file that goes a little something like this....
EUR;EUR;EUR:USD:USD;USD;;;EUR/USD;XAU/AUD;XAU/EUR;XAU/AUD,GBP/BOB,UAD/XAU;;;1.11;2.22;3.33;4.44;5.55;6.66;;;
is it possible to... (7 Replies)
i have something like this
abc 123 3234 1234 * qqoiki * abc 4533 34 1234 * lloiki *
i want to make it two lines i,e.,abc 123 3234 1234 * qqoiki *
abc 4533 34 1234 * lloiki * how to do that ? (13 Replies)
Hi,
I have a requirement where in I need to insert delimiters before the last column of the total delimiters is less than a specified number.
Say if the delimiters is less than 139, I need to insert 2 columns ( with blanks) before the last field
awk -F 'Ç' '{ if (NF-1 < 139)} END { "Insert 2... (5 Replies)
I have a comma delimited file as per the one below and I am currently extracting the values in 2 columns (COL1 & COL6) to produce a smaller trimmed down version of the file which only contains the columns we need;
COL1,COL2,COL3,COL4,COL5,COL6,COL7,COL8,COL9... (1 Reply)
For shell script. If I had two separate files, file.txt and file1.txt and each has just a list of names from the who command. How would I create an if loop to compare each name? (1 Reply)
Discussion started by: Eric7giants
1 Replies
LEARN ABOUT PHP
pg_copy_from
PG_COPY_FROM(3)PG_COPY_FROM(3)pg_copy_from - Insert records into a table from an arraySYNOPSIS
bool pg_copy_from (resource $connection, string $table_name, array $rows, [string $delimiter], [string $null_as])
DESCRIPTION pg_copy_from(3) inserts records into a table from $rows. It issues a COPY FROM SQL command internally to insert records.
PARAMETERS
o $connection
- PostgreSQL database connection resource.
o $table_name
- Name of the table into which to copy the $rows.
o $rows
- An array of data to be copied into $table_name. Each value in $rows becomes a row in $table_name. Each value in $rows should be
a delimited string of the values to insert into each field. Values should be linefeed terminated.
o $delimiter
- The token that separates values for each field in each element of $rows. Default is TAB.
o $null_as
- How SQL NULL values are represented in the $rows. Default is N ("\N").
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
pg_copy_from(3) example
<?php
$db = pg_connect("dbname=publisher") or die("Could not connect");
$rows = pg_copy_to($db, $table_name);
pg_query($db, "DELETE FROM $table_name");
pg_copy_from($db, $table_name, $rows);
?>
SEE ALSO pg_copy_to(3).
PHP Documentation Group PG_COPY_FROM(3)