| 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: | Whole Thread | Raw Message | 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.
| 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 |
| 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 |