| From: | Mark Jewiss <Mark(dot)Jewiss(at)knowledge(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Input from files |
| Date: | 1999-09-10 14:46:46 |
| Message-ID: | Pine.BSO.4.10.9909101543490.22294-100000@office.knowledge.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I often use psql -f <filename> to input data from files that come from
legacy systems/other people.
Is there a way to input these into pgsql without the file having any
insert commands into it?
I've been given a large csv file that has come straight out of MS Excel,
and don't really want to have to go all through the file entering the
insert commands on either side of the values. Although I could use vi's
global search and replace, but that is messy.
Basically I just want to input a raw csv file....
Regards,
Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Samersoff | 1999-09-10 15:21:55 | RE: [HACKERS] Re: Query about postgres medical database |
| Previous Message | Oleg Broytmann | 1999-09-10 14:24:09 | Re: [HACKERS] Re: Query about postgres medical database |