10-19-2010
The answer is that you probably have unnecessaily complex perl code; yes, awk, perl or some other languages all work well. We have searches like that on 10M rows that take less than 2 minutes.
Please give us a few sample rows, sample output, and point out the field that is the primary key.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi Guys,
Requirement: Want to compare two files, if the the content of both files is same then show "Good result" else Show "Bad Result"
I am using the following logic
if( cmp -s a b = 0 )
then
echo "Good result"
else echo "Bad result"
exit 0
fi
But this is... (1 Reply)
Discussion started by: abhishek3598
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I need to compare 2 files based on the first field in each file and output the differences to a new file.
example File 1 and File 2 both have first field as Number ie:
File 1
1252652355
1859553322
1778899562
File 2
1252652355
1859553322
So I would expect File 3 to... (2 Replies)
Discussion started by: Lagre1
2 Replies
3. Shell Programming and Scripting
Hi Friends,
I have a requirement like i have two files in diffrent locations. i want to compare these two files, if both the files are same i want to return "0" else return 1.
Please help me on this.
Thanks
sreenu. (3 Replies)
Discussion started by: sreenu80
3 Replies
4. UNIX for Dummies Questions & Answers
how can i unix compare two files??
var1 = 6499 7328 6351 7583 7573
var2 = 6499 7328 6351 7583 7777
i did:
diff $var1 $var2
and i got the output:
1c1
< 6499 7328 6351 7583 7573
---
> 6499 7328 6351 7583 7777
what can i do with it? and what does it tell me?? how can i knoe that... (2 Replies)
Discussion started by: nirnir26
2 Replies
5. Shell Programming and Scripting
Hi Gurus
I need your kind help sorting the below query
I have two text files
File1.txt
ID Name Address
101 Srinath BBB
102 Sidharth CCC
File2.txt
ID Name Address
102 Siddharth DDD
103 Suman EEE
Now the requirement is if the second file has... (0 Replies)
Discussion started by: Pratik4891
0 Replies
6. Shell Programming and Scripting
Hi,
I have two files
File1 Contents:
abc
dcf
sdc
File2 Contents:
dcf
sdc
erg
Now my program should return the contents existing in File1 but not in File2. In this case output shoud be "abc" as abc is not available in File 2. It should not return "erg" by saying it is... (4 Replies)
Discussion started by: forums123456
4 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I have a dat file nctilllist.dat which will be present in the directory path
"/usr/lpp/web-data/mfg/nct/file-data/nctilllist.dat"
nctillist.dat will have reference to files like DP100001.jpg,DP10002.PDF,DP100003.doc
on the path /usr/lpp/web-data/mfg/nct/file-data will have... (12 Replies)
Discussion started by: gayathrivm
12 Replies
8. Shell Programming and Scripting
I have a file containing the below data obtained after running a diff command
> abc 10
< abc 15
> xyz 02
<xyz 05
.....
Does anyone know how i can obtain output like :
previous value of abc is 10 and present value is 15
similarly for all the comparisons in the text file (10 Replies)
Discussion started by: amithpatrick1
10 Replies
9. Shell Programming and Scripting
I have requirement to compare two files in unix. Below are the sample files.
File1:
cn=test123,cn=bobgroup,dc=ind,dc=com
cn=bob123,cn=bobgroup,dc=ind,dc=com
cn=test13,cn=bobgroup,dc=ind,dc=com
cn=est12,cn=bobgroup,dc=ind,dc=com
cn=st123,cn=bobgroup,dc=ind,dc=com
File2... (1 Reply)
Discussion started by: babu92
1 Replies
10. Shell Programming and Scripting
Hi,
I have below query related to multiple file comparing
I have four files i want to compare it and contents of one file will not be presence in 3other files and if any content found then it will print the execution.
Can you please help me how to achieve it. (2 Replies)
Discussion started by: soumyamihp
2 Replies
LEARN ABOUT CENTOS
dblink_get_pkey
DBLINK_GET_PKEY(3) PostgreSQL 9.2.7 Documentation DBLINK_GET_PKEY(3)
NAME
dblink_get_pkey - returns the positions and field names of a relation's primary key fields
SYNOPSIS
dblink_get_pkey(text relname) returns setof dblink_pkey_results
DESCRIPTION
dblink_get_pkey provides information about the primary key of a relation in the local database. This is sometimes useful in generating
queries to be sent to remote databases.
ARGUMENTS
relname
Name of a local relation, for example foo or myschema.mytab. Include double quotes if the name is mixed-case or contains special
characters, for example "FooBar"; without quotes, the string will be folded to lower case.
RETURN VALUE
Returns one row for each primary key field, or no rows if the relation has no primary key. The result row type is defined as
CREATE TYPE dblink_pkey_results AS (position int, colname text);
The position column simply runs from 1 to N; it is the number of the field within the primary key, not the number within the table's
columns.
EXAMPLES
CREATE TABLE foobar (
f1 int,
f2 int,
f3 int,
PRIMARY KEY (f1, f2, f3)
);
CREATE TABLE
SELECT * FROM dblink_get_pkey('foobar');
position | colname
----------+---------
1 | f1
2 | f2
3 | f3
(3 rows)
PostgreSQL 9.2.7 2014-02-17 DBLINK_GET_PKEY(3)