From lu@cs.umn.edu Fri Jun 12 14:27:18 1998 Received: from augustus-239.cs.umn.edu (root@augustus.cs.umn.edu [128.101.229.71]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA01748 for ; Fri, 12 Jun 1998 10:27:18 -0400 (EDT) Received: from hunan (cs-line3.cs.umn.edu [128.101.230.90]) by augustus-239.cs.umn.edu (8.8.5/8.8.5) with SMTP id JAA15682; Fri, 12 Jun 1998 09:27:16 -0500 (CDT) Message-ID: <001c01bd95dc$6ad83560$5ae66580@hunan.cs.umn.edu> From: "Yingpling Lu" To: Subject: how to bulky-copy data in postgreSql Date: Fri, 12 Jun 1998 09:30:53 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0019_01BD95E4.CC9B16C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 This is a multi-part message in MIME format. ------=_NextPart_000_0019_01BD95E4.CC9B16C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I'm going to port my database from Ms access to postgreSql. But I don't = know if there is a bulky copy statement in PostgreSql. I checked all = your documents in your web site but cann't find it. There should be a = statament like=20 load data file into table .... Can you tell me how to do that? Thanks. Peter ------=_NextPart_000_0019_01BD95E4.CC9B16C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
I'm going to port my database from = Ms access to=20 postgreSql. But I don't know if there is a bulky copy statement in = PostgreSql. I=20 checked all your documents in your web site but cann't find it. There = should be=20 a statament like
load data file into table = ....
Can you tell me how to do = that?
Thanks.
Peter
------=_NextPart_000_0019_01BD95E4.CC9B16C0-- From djackson@cpsgroup.com Fri Jun 12 15:43:47 1998 Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.8.8/8.7.5) with ESMTP id LAA12609 for ; Fri, 12 Jun 1998 11:43:47 -0400 (EDT) Received: by bjke.com; id LAA05630; Fri, 12 Jun 1998 11:41:13 -0400 (EDT) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (3.2) id xmaa05064; Fri, 12 Jun 98 11:40:36 -0400 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id ; Fri, 12 Jun 1998 10:43:43 -0500 Message-ID: From: "Jackson, DeJuan" To: Yingpling Lu , pgsql-sql@postgreSQL.org Subject: RE: [SQL] how to bulky-copy data in postgreSql Date: Fri, 12 Jun 1998 10:43:41 -0500 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain Look at the 'COPY' statement and/or the '\copy' commend in psql. -DEJ > -----Original Message----- > From: Yingpling Lu [SMTP:lu@cs.umn.edu] > Sent: Friday, June 12, 1998 3:31 AM > To: pgsql-sql@postgreSQL.org > Subject: [SQL] how to bulky-copy data in postgreSql > > Hi, > I'm going to port my database from Ms access to postgreSql. But I > don't know if there is a bulky copy statement in PostgreSql. I checked > all your documents in your web site but cann't find it. There should > be a statament like > load data file into table .... > Can you tell me how to do that? > Thanks. > Peter