ivan marchesini <[EMAIL PROTECTED]> writes:
> I have a .txt file, containing some tabular data, where data are
> delimited by TABs.
> there are 3 columns:
> column1 int4, column2 float8, column3 float8
> the problem is that column3 contains also null values (i.e. sometimes is
> empty)
This should
yup... Replace the empty spaces in the file with some other value...
replace null values with \N
then try COPYing againOn 3/22/06, Luckys <[EMAIL PROTECTED]> wrote:
On 3/22/06, Achilleus Mantzios <
[EMAIL PROTECTED]> wrote:
O ivan marchesini έγραψε στις Mar 22, 2006 :> Dear users,> I'm working
On 3/22/06, Achilleus Mantzios <[EMAIL PROTECTED]> wrote:
O ivan marchesini έγραψε στις Mar 22, 2006 :> Dear users,> I'm working on a Postgres 7.4
server>> I have a .txt file, containing some tabular data, where data are> delimited by TABs.> there are 3 columns:>> column1 int4, column2 float8, co
O ivan marchesini έγραψε στις Mar 22, 2006 :
> Dear users,
> I'm working on a Postgres 7.4 server
>
> I have a .txt file, containing some tabular data, where data are
> delimited by TABs.
> there are 3 columns:
>
> column1 int4, column2 float8, column3 float8
>
> the problem is that column3 con
Dear users,
I'm working on a Postgres 7.4 server
I have a .txt file, containing some tabular data, where data are
delimited by TABs.
there are 3 columns:
column1 int4, column2 float8, column3 float8
the problem is that column3 contains also null values (i.e. sometimes is
empty)
so when I try to
