X-Original-To: pgsql-sql@postgresql.org
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id 699F3475EBB
	for <pgsql-sql@postgresql.org>; Mon, 10 Mar 2003 01:07:18 -0500 (EST)
Received: by news.hub.org (Postfix, from userid 8)
	id 53CEA43A611; Mon, 10 Mar 2003 01:07:18 -0500 (EST)
From: "mark carew" <markcarew@bigpond.com>
X-Newsgroups: comp.databases.postgresql.sql
Subject: Re: Insert multiple Rows
Date: Sun, 9 Mar 2003 15:58:57 +1000
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 17
Message-ID: <b4ha2l$2566$1@news.hub.org>
References: <6f079210.0303030838.21f184af@posting.google.com>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
To: pgsql-sql@postgresql.org
X-Archive-Number: 200303/249
X-Sequence-Number: 12289

Hi
    HTH

COPY [ BINARY ] table [ WITH OIDS]
    FROM { 'filename' | stdin}
    [  [  USING ] DELIMITERS 'delimiter' ]
    [ WITH NULL AS 'null_string' ]

 COPY [ BINARY ] table [ WITH OIDS]
    TO { 'filename' | stdin}
    [  [  USING ] DELIMITERS 'delimiter' ]
    [ WITH NULL AS 'null_string' ]

Regards Mark Carew
                Brisbane Australia