Re: M$ SQL server DTS package equivalent in Postgres - Mailing list pgsql-ports

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.