Re: New to Postgres

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