Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4B6CE9FB5CC for ; Tue, 23 Jan 2007 18:32:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 70732-01 for ; Tue, 23 Jan 2007 18:32:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 748689FB5C9 for ; Tue, 23 Jan 2007 18:32:13 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail22.syd.optusnet.com.au (mail22.syd.optusnet.com.au [211.29.133.160]) by svr4.postgresql.org (Postfix) with ESMTP id 75CE25AFB9E for ; Tue, 23 Jan 2007 22:32:11 +0000 (GMT) Received: from [58.104.78.149] (d58-104-78-149.dsl.vic.optusnet.com.au [58.104.78.149]) (authenticated sender plengada) by mail22.syd.optusnet.com.au (8.13.1/8.13.1) with ESMTP id l0NMVwk2029470; Wed, 24 Jan 2007 09:32:00 +1100 Message-ID: <45B68CFB.3070201@autoledgers.com.au> Date: Wed, 24 Jan 2007 07:32:27 +0900 From: Paul Lambert User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Magnus Hagander Cc: pgsql-ports@postgresql.org Subject: Re: M$ SQL server DTS package equivalent in Postgres References: <45B5619A.6040404@autoledgers.com.au> <20070123085612.GB14759@svr2.hagander.net> In-Reply-To: <20070123085612.GB14759@svr2.hagander.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200701/5 X-Sequence-Number: 2513 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. > > > > 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.