:) Import file2table Question

From: Korapat Charukumnerdkanok <korapat(dot)c(at)cdg(dot)co(dot)th>
To: pgsql-general(at)postgreSQL(dot)org
Subject: :) Import file2table Question
Date: 1998-07-06 09:31:31
Message-ID: 35A09973.15A3@cdg.co.th
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Good Morning,

@^_^@

Could you please tell me ....

1 -How can I import a text file into Postgres table ?
(append to the last row)

-What is the format of that text file ?

This is what I've done and its result....

ProjDB=> copy PrjTB from /prj_data/test.txt using delimiters ,
ProjDB-> ;
ERROR: parser: syntax error at or near "/"

2 -What table field type that suits for 6-digit decimal number..
(i.e. 0.000000, 0.250001 , 0.123456 , ....)?

I've defined this column with float4 and float8
but when I inserted data it returned this error message..

ProjDB=> insert into PrjTB values (0.000000,'red','Ln1')
ProjDB->;
ERROR: pg_atoi: error in "0.000000": can't parse ".000000"

Thank You for your advance help,
Korapat Charu.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roman Volkoff 1998-07-06 10:10:55 unsubscribe
Previous Message Jrgen Siepmann 1998-07-05 20:43:30 documentation

Browse pgsql-sql by date

  From Date Subject
Next Message BD Postgres 1998-07-06 10:14:29 sql date functions
Previous Message Kurt J. Hoell 1998-07-05 10:26:16 Re: [SQL] select w/Swing's JTable widget