Skip site navigation (1) Skip section navigation (2)

Fixed field text import

From: Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Fixed field text import
Date: 2003-10-31 00:58:56
Message-ID: 20031031135626.H35878-100000@storm.niwa.co.nz (view raw or flat)
Thread:
Lists: pgsql-general

Is there an easy way (similar to COPY) to import fixed width text files
directly into Postgres tables?

COPY is fine for files with delimited fields, but I have fixed format text
files to import into tables.



Thanks,

  Brent Wood


In response to

Responses

pgsql-general by date

Next:From: David BusbyDate: 2003-10-31 01:05:23
Subject: Best Perl Option?
Previous:From: Chris StokesDate: 2003-10-31 00:54:55
Subject: database speed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group