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
__________________________________________________ _______________
Try Live.com: where your online world comes together - with news, sports, weather, and much more.
http://www.live.com/getstarted

> 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.

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

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings