Re: M$ SQL server DTS package equivalent in Postgres

[Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>]

Magnus Hagander wrote:
> On Tue, Jan 23, 2007 at 10:15:06AM +0900, Paul Lambert wrote:
> > [snip]
>
> This you can do using plain COPY commands from psql. You acn script this
> as a SQL file. Or you can script using your faviourite scripting
> language such as perl or python or whatever. What we don't do is the
> advanced transformation features in DTS, but if you're just loading data
> it's fully supported.
>
>
> <snip>
> Looks like a plaitnext file with ^ as field delimiter. See the help for
> COPY on how to load that.
>
> //Magnus

Thanks for that, looks exactly like what I wanted.

Appreciate the suggestion.

Regards,
Paul.