From: Peter Eisentraut <peter_e@gmx.net>
To: Rodrigo Sakai <rodrigo@2bfree.com.br>
To: pgsql-sql@postgresql.org
Subject: Re: Importation wtih copy generated some wrong registers..
Date: Wed, 7 Jan 2004 19:41:25 +0100
Message-ID: <200401071941.25114.peter_e@gmx.net> (raw)
In-Reply-To: <20040107135846.25590.qmail@hm10.locaweb.com.br>
References: <20040107135846.25590.qmail@hm10.locaweb.com.br>
Rodrigo Sakai wrote:
> I did some importation from a .csv file to a table
>
> (this is a very small piece of the csv file, but i think its good for
> the exemple. the pipe "|" is the delimiter for this file)
> 001|002|30413000000045027612|002
> 001|002|30410000000218146611|002
> 001|002|30406000000664389616|002
> 001|002|30406000000607799814|002
> 001|002|30406000000664429313|002
> 001|002|30406000000607767316|002
>
>
> (and the respective part of the table is)
> cod_empresa int4 NOT NULL,
> cod_credor int4 NOT NULL,
> num_contr varchar(50) NOT NULL,
> cod_filial int4 NOT NULL DEFAULT 1
>
>
> (so, the data on my tables look like this:)
> cod_empresa | cod_cliente | num_contr | cod_filial
> -------------+-------------+-----------------------+------------
> 1 | 9386 | 30410000000762732212 | 3
> 1 | 7383 | 3,04100000007634E+019 | 4
> 1 | 5750 | 30410000000763546413 | 3
> 1 | 3584 | 3,04100000007627E+019 | 6
This result has mighty little to do with what you are importing, so
you're either looking at the wrong table or you have some triggers that
do heavy massage on your data.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: peter_e@gmx.net, rodrigo@2bfree.com.br
Subject: Re: Importation wtih copy generated some wrong registers..
In-Reply-To: <200401071941.25114.peter_e@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox