Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres copy - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: postgres copy
Date
Msg-id 200111011736.fA1HamYT000983@linda.lfix.co.uk
Whole thread Raw
In response to postgres copy  ("samsom, debra" <dsamsom@bristol.ca>)
List pgsql-novice
Tree view 
"samsom, debra" wrote:
  >Is there away to copy fixed length text files into an Postgresql table.
  >After reading the doc's it looks Postgresql expects some sort of delimiter.

Filter the data through perl or awk to insert delimiters.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "But they that wait upon the LORD shall renew their
      strength; they shall mount up with wings as eagles;
      they shall run, and not be weary; and they shall walk,
      and not faint."            Isaiah 40:31

pgsql-novice by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [GENERAL] CP1250 to and from Unicode conversion, how?
Next
From: Tom Lane
Date:
Subject: Re: Triggers failing from 7.0.2 to 7.1.3