Re: DTS

From: Aled Morris <aled(dot)morris(at)infomatiq(dot)co(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: DTS
Date: 2003-09-22 07:55:21
Message-ID: 200309220855.21900.aled.morris@infomatiq.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

DTS on SQL Server does a whole bunch more than loading textfiles into the
database. But if that's all you want to do then use the PostgreSQL command
"COPY".

AM

On Tuesday 16 Sep 2003 4:27 pm, Juan Francisco Diaz wrote:
> Hi, in SQLServer there is something called DTS, we in our race to improve
> the load of millions of records are planning to use them on SQLServer. BUT
> we would like to achieve similar performance in postgresql via something
> like that.
> Is this possible? Is there any way to emulate the DTS?
> If not, is it possible to write a function that loads a textfile onto the
> DB using plpgsql?
>
> Thanks!
>
> JuanF
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--

Aled Morris
---------------------------
aled(dot)morris(at)infomatiq(dot)co(dot)uk

In response to

  • DTS at 2003-09-16 15:27:52 from Juan Francisco Diaz

Browse pgsql-novice by date

  From Date Subject
Next Message Bryan Irvine 2003-09-22 16:47:29 Replication
Previous Message Oliver Elphick 2003-09-22 06:17:39 Re: Create tables based on another table