Re: [PORTS] M$ SQL server DTS package equivalent in Postgres

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.

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate