06-10-2010
I recommend the following programmatic solution.
A.) Build a program that splits the paragraphs out into files named with the table_nm: table_nm.sch. For each file1, file2, store these schema files in a separate directory.
B.) Build another program to diff each file individually and then report in whatever format you like.
Give it your best shot. We'll assist in any debugging.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have 2 files
file 1---------> hello
file 2---------> hello world
is there any command that we find the diff b/w two files and gives the ans as what is not matched with file 2.
diff file 1 file 2
here the desired o/p should be: world
as "world" is not found in file 1. (2 Replies)
Discussion started by: ali560045
2 Replies
2. Shell Programming and Scripting
I know the basic difference between .pm and .pl files. But wat puzzles me is when to go for creating a module and when to create .pl files.Based on wat criteria we sholud decide to make a function whcih implements a common functionality as module or a .pl file ?? (3 Replies)
Discussion started by: Anuj8584
3 Replies
3. Shell Programming and Scripting
Hi All,
I need your help to find out the difference between 3 files.
How can i get the output which says that FILE2 contains additional (YYY,900,100) compare to FILE1 and FILE3 contains addition record (ZZZ,904,908) compare to FILE1?
I have tried using diff3 command, but was not able to get... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies
4. Shell Programming and Scripting
I have two files like follows: -
File 1: -
A 20
B 15
D 10
C 6
File 2: -
B 21
A 20
C 11
D 10
Now I want file like this: -
It should pick up 'A' from File 1 and pick up 'A' from File 2 and should get difference of the numbers in 2nd column and display result as follows ... (2 Replies)
Discussion started by: balu_puttaganti
2 Replies
5. Shell Programming and Scripting
HI Folks,
sorry if it is a naive question.
i have two files . "file1.txt" & "file2.txt"
contents in files:
file1.txt file2.txt
-------- ---------
1 ... (2 Replies)
Discussion started by: babusek
2 Replies
6. Shell Programming and Scripting
i have two files A and B and i want the difference to be printed in file C
as in example below
File A
10E32E7BCC5881DDB6||002878|1|1|
10E32E7BCC5881DDB7||002878|1|1|
10E32E7BCC5881DDB8||002878|1|1|
10E32E7BCC5881DDB9||002878|1|1|
File B
10E32E7BCC5881DDB1||002878|1|1|... (4 Replies)
Discussion started by: tomjones
4 Replies
7. UNIX for Advanced & Expert Users
I need the get the difference between 2 files and the result, I need to output it to an other file
file1
1
1
2
file2
1
1
2
3
Result....File3=3
used diff file1 file2 > file3 ( not working as expected)..Exact requirement..I have 2 flatfiles to compare and load only the difference in a... (0 Replies)
Discussion started by: win4luv
0 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I have problem in finding the difference. suppose i have two file
file1 file2
1xyz 1xyz
1asd 1xyz
1asd 1abc
2adf 1asd
3asd 2abd
4abc 2adf
3asf
I need to... (7 Replies)
Discussion started by: XXLMMN
7 Replies
9. Shell Programming and Scripting
HI Team,
Could you please help me here.
I need to compare 4 files
a)
1
2
3
4
b)
1
5
3
4
c)
1
2
5 (1 Reply)
Discussion started by: madhuchilipi
1 Replies
10. UNIX for Beginners Questions & Answers
I have two file as given below which shows the ACL permissions of each file. I need to compare the source file with target file and list down the difference as specified below in required output. Can someone help me on this ?
Source File
*************
# file: /local/test_1
# owner: own
#... (4 Replies)
Discussion started by: sarathy_a35
4 Replies
LEARN ABOUT CENTOS
create_tablespace
CREATE
TABLESPACE(7) PostgreSQL 9.2.7 Documentation CREATE TABLESPACE(7)
NAME
CREATE_TABLESPACE - define a new tablespace
SYNOPSIS
CREATE TABLESPACE tablespace_name [ OWNER user_name ] LOCATION 'directory'
DESCRIPTION
CREATE TABLESPACE registers a new cluster-wide tablespace. The tablespace name must be distinct from the name of any existing tablespace in
the database cluster.
A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects (such
as tables and indexes) can reside.
A user with appropriate privileges can pass tablespace_name to CREATE DATABASE, CREATE TABLE, CREATE INDEX or ADD CONSTRAINT to have the
data files for these objects stored within the specified tablespace.
PARAMETERS
tablespace_name
The name of a tablespace to be created. The name cannot begin with pg_, as such names are reserved for system tablespaces.
user_name
The name of the user who will own the tablespace. If omitted, defaults to the user executing the command. Only superusers can create
tablespaces, but they can assign ownership of tablespaces to non-superusers.
directory
The directory that will be used for the tablespace. The directory should be empty and must be owned by the PostgreSQL system user. The
directory must be specified by an absolute path name.
NOTES
Tablespaces are only supported on systems that support symbolic links.
CREATE TABLESPACE cannot be executed inside a transaction block.
EXAMPLES
Create a tablespace dbspace at /data/dbs:
CREATE TABLESPACE dbspace LOCATION '/data/dbs';
Create a tablespace indexspace at /data/indexes owned by user genevieve:
CREATE TABLESPACE indexspace OWNER genevieve LOCATION '/data/indexes';
COMPATIBILITY
CREATE TABLESPACE is a PostgreSQL extension.
SEE ALSO
CREATE DATABASE (CREATE_DATABASE(7)), CREATE TABLE (CREATE_TABLE(7)), CREATE INDEX (CREATE_INDEX(7)), DROP TABLESPACE (DROP_TABLESPACE(7)),
ALTER TABLESPACE (ALTER_TABLESPACE(7))
PostgreSQL 9.2.7 2014-02-17 CREATE TABLESPACE(7)