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
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 |