The answer is simple no. I know I can to some preprocessing on input
files using awk, sed etc. but don't want to change the structure of the
file.
Colin Wetherbee wrote:
Andrej Kastrin wrote:
||5354235||,||some text...|| ||1234567||,||some text...||
||1234568||,||some text...||
Th
Dear all,
I have to copy the file with the following delimiters into the database:
||5354235||,||some text...||
||1234567||,||some text...||
||1234568||,||some text...||
The sql statement I defined was:
COPY testtable FROM 'test.txt' WITH DELIMITER AS ',' CSV QUOTE AS '||';
but the error:
ER
A. Kretschmer wrote:
am Sun, dem 10.06.2007, um 13:41:27 +0200 mailte Andrej Kastrin folgendes:
Dear all,
I need to count all pairs of instances which occure under given ID
number, e.g.:
ID word
-
1 car
1 fruit
2 car
2 fruit
2 vegetable
3 car
3 vegetable
And
Dear all,
I need to count all pairs of instances which occure under given ID
number, e.g.:
ID word
-
1 car
1 fruit
2 car
2 fruit
2 vegetable
3 car
3 vegetable
And the output should be simillar to:
car fruit 2
car vegetable 2
fruit vegetable 1
Any suggestion how t
hubert depesz lubaczewski wrote:
On 6/3/07, *Andrej Kastrin* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
||001||,||Classification||,||Economics||,||N||
||001||,||Classification||,||Trends||,||Y||
etc...
it looks like you should be able to read it using
Dear all,
I am experiencing difficulty in trying to copy the file structure below
into PostgreSQL table:
||001||,||Classification||,||Economics||,||N||
||001||,||Classification||,||Trends||,||Y||
etc...
Although I can preprocess the input file with e.g awk, I would like to
know is it possibl
Dear pgsql users,
I have a problem, which is quite hard to solve it in Perl (for me, of
course). I have to tables, which looks like
First Table:
1|001|002|003
2|006|04|002
Second Table:
001|text1|text2|text3
002|text6|text1|text2
Now I would like to concatenate this two tables into new table:
