Fixed column format data - PostgreSQL Database

Greg Stark

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

Subscribe Post Reply

1973

Shridhar Daithankar

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

Similar topics

RSet and Fixed Length Strings

by: Adrian Parker | last post by:

I'm using the code below in my project. When I print all of these fixed length string variables, one per line, they strings in questions do not properly pad with 0s. strQuantity prints as " ...

Visual Basic 4 / 5 / 6

179

Keeping Web Page at Fixed Width

by: SoloCDM | last post by:

How do I keep my entire web page at a fixed width? ********************************************************************* Signed, SoloCDM

HTML / CSS

DatagridStyle Control problem

by: Billy Jacobs | last post by:

I have created a DataGridColumnDatePicker Component so that I can put a datetimepicker control in my datagrid. It almost works. When I put my mouse in the cell it changes to a datetimepicker...

.NET Framework

BCP and treatment of NULLs when export to fixed format text file

by: ezelasky | last post by:

We are using the bcp utility (via APIs) to export data from a SQL table in a fixed format text file. BCP is inserting spaces for a field if the field contains a NULL. This is fine with us except...

Microsoft SQL Server

Table Widget for IE? Fixed header, sorting columns, etc

by: Matt Kruse | last post by:

I'm looking for the best JS/CSS solution to add functionality to tables. The only browser which needs to be supported is IE5.5+, but no activeX can be used. to be able to do: - Fixed header row...

Javascript

MSFlex Grid Control - Fixed Rows

by: Otie | last post by:

Hello, I am using the MSFlexGrd Control in VB5. I have 1 fixed row and one fixed column. I am trying to do a sort when the user clicks a column in the FIXED ROW. But when I capture the row...

Visual Basic 4 / 5 / 6

Bulk Insert - Fixed Length File

by: Jennifer | last post by:

I'm trying to do an insert using Bulk Insert with a fixed length file. I'm using a format file. I'm getting the following error message: Cannot perform bulk insert. Invalid collation name for...

Microsoft SQL Server

fixed width format

by: gokhalen | last post by:

How can I print between column number 8 and column number 80?. Is there a format specifier that will do it easily?. I am printing an array of doubles and I want the number to be printed on the...

C / C++

Fixed-Width Text Format

by: Jeff | last post by:

Hey I'm wondering how the Fixed-Width Text Format is What I know is that the top line in this text format will contain column names. and each row beneath the top line represent for example a...

C# / C Sharp

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++