Thread: New to Postgres

I'm new to PostgreSQL.  I have a background as an Oracle PL/SQL programmer.  I'm wondering if there's a comparable Postgres utility to Oracle's SQL*Loader?  I have several large fixed record length files that I need to load into the Postgres db.  Currently, I'm using the COPY command to load the data into temporary tables; I then parse the data and insert into a new table.   I'm wondering if there is a better solution.  Any help would be appreciated.


J. Michael Nees 
jmnees@hotmail.com

---

Be one of the first to try Windows Live Mail. Windows Live Mail.

> I'm new to PostgreSQL.  I have a background as an Oracle PL/SQL programmer.  I'm wondering if
> there's a comparable Postgres utility to Oracle's SQL*Loader?  I have several large fixed record
> length files that I need to load into the Postgres db.  Currently, I'm using the COPY command to
> load the data into temporary tables; I then parse the data and insert into a new table.   I'm
> wondering if there is a better solution.  Any help would be appreciated.J. Michael Nees
> jmnees@hotmail.com

The may be some tools that you could search for under the section "other software"
http://www.postgresql.org/download/


However, most of the answers to questions like yours boil down to how well you know perl or
plperl.

:-)

Regards,

Richard Broersma Jr.

On 8/12/06, Mike Nees <jmnees@hotmail.com> wrote:
>
> I'm new to PostgreSQL.  I have a background as an Oracle PL/SQL programmer.
> I'm wondering if there's a comparable Postgres utility to Oracle's
> SQL*Loader?  I have several large fixed record length files that I need to
> load into the Postgres db.  Currently, I'm using the COPY command to load
> the data into temporary tables; I then parse the data and insert into a new
> table.   I'm wondering if there is a better solution.  Any help would be
> appreciated.
Or, in addition to Richards suggestion, you could conceivably
(you forgot to mention which OS you're using Postgres under)
use command-line tools like awk to put your data into a proper
format before you pipe it to your COPY command.

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm