<div>
If you can cope with the Large Object Type then see.<br />
file:///usr/share/doc/post<wbr />gresql-8.2<wbr />.3/html/lo<wbr />-examplese<wbr />ct.html
</div>


If you can cope with the Large Object Type then see.
file:///usr/share/doc/postgresql-8.2.3/html/lo-examplesect.html

<div>
Where is this file at? &nbsp;I looked in my local postgresql folder for this html file, but could not locate it...
</div>


Where is this file at?  I looked in my local postgresql folder for this html file, but could not locate it...

<div>
Client-Side functions lo_import lo_export may be just the feature you are looking for.
</div>


Client-Side functions lo_import lo_export may be just the feature you are looking for.

<div>
Once the file is in the database, is there a way to break it up into separate columns and then use it to poulate several columns within a table?<br />
<br />
Do you have an example of how this works?
</div>


Once the file is in the database, is there a way to break it up into separate columns and then use it to poulate several columns within a table?

Do you have an example of how this works?

<div>
<div class="content wysiwyg-content">
I need to Import a Fixed Length File into PostgreSQL Database. &nbsp;Preferrably I need to create a function or stored proc that can be ran periodically when receiving a new data file. &nbsp;Eventually, I would like to be able to do this via an automated script. &nbsp;Please help, I am new to PostgreSQL and come from a SQL Server DTS background...
</div>
</div>


I need to Import a Fixed Length File into PostgreSQL Database.  Preferrably I need to create a function or stored proc that can be ran periodically when receiving a new data file.  Eventually, I would like to be able to do this via an automated script.  Please help, I am new to PostgreSQL and come from a SQL Server DTS background...

Import Fixed Length File into PostgreSQL Database

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.