By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,777 Members | 1,755 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,777 IT Pros & Developers. It's quick & easy.

Fixed column format data

P: n/a

Is there any facility to import a text file that's in fixed column format? The
copy command seems to use a delimiter only. I have no delimiter, but have
specified column widths.

Are the only ways to either do many insert queries, or preprocess the file
into a delimited file and then copy?

--
greg
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thursday 06 November 2003 21:00, Greg Stark wrote:
Is there any facility to import a text file that's in fixed column format?
The copy command seems to use a delimiter only. I have no delimiter, but
have specified column widths.

Are the only ways to either do many insert queries, or preprocess the file
into a delimited file and then copy?


Well, a simple C program would do the job, isn't it? Of course there could be
some scripting solutions but I don't have anything offhand..

Shridhar
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.