From sharmad@im.eth.net Sun Jan 14 15:36:33 2001 Received: from im.eth.net (mail.uthplanet.com [202.9.136.18]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0EFaXp54013 for ; Sun, 14 Jan 2001 10:36:33 -0500 (EST) (envelope-from sharmad@im.eth.net) Received: from SharmadNaik ([61.11.9.146]) by im.eth.net with Microsoft SMTPSVC(5.5.1877.117.11); Sun, 14 Jan 2001 21:01:51 +0530 Message-ID: <000a01c07e3d$228dd840$92090b3d@SharmadNaik> From: "Sharmad Naik" To: "PGSQL-SQL" Subject: importing of ISO file to Postgresql Date: Sun, 14 Jan 2001 20:46:14 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C07E6B.096E5500" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200101/132 X-Sequence-Number: 793 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C07E6B.096E5500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Sir, I m doing a library management program using Postgresql as backend. We = are given an ISO 2709 format flat file which is only a books dbase which is= to be converted to postgres format My Q is that where should I import the file ? Please if possible specif= y the file or directory where it is to be imported ? Possibly if u have tim= e please explain me the whole process out of ur time.... Thanks a lot, Sharmad ------=_NextPart_000_0007_01C07E6B.096E5500 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Sir,
    I m doing a library=20 management program using Postgresql as backend. We are given an= ISO=20 2709 format flat file which is only a books dbase which is to be= =20 converted to postgres format
    My Q is that where shou= ld I=20 import the file ? Please if possible specify the file or directory where it= is=20 to be imported ? Possibly if u have time please explain me the whole proces= s out=20 of ur time....
    Thanks a lot,
 
Sharmad
------=_NextPart_000_0007_01C07E6B.096E5500-- From pyz@panix.com Sun Jan 14 20:33:53 2001 Received: from mail1.panix.com (mail1.panix.com [166.84.0.212]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0EKXrp72813 for ; Sun, 14 Jan 2001 15:33:53 -0500 (EST) (envelope-from pyz@panix.com) Received: from panix.com (mail2.panix.com [166.84.0.213]) by mail1.panix.com (Postfix) with ESMTP id AFD024892B; Sun, 14 Jan 2001 15:33:51 -0500 (EST) Received: from panix.com (pyz.dialup.access.net [166.84.202.155]) by panix.com (Postfix) with ESMTP id 091A843B25; Sun, 14 Jan 2001 15:30:28 -0500 (EST) Message-ID: <3A620BFC.192374CA@panix.com> Date: Sun, 14 Jan 2001 15:28:44 -0500 From: Max Pyziur Organization: BRAMA - Gateway Ukraine X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Sharmad Naik Cc: PGSQL-SQL Subject: Re: importing of ISO file to Postgresql References: <000a01c07e3d$228dd840$92090b3d@SharmadNaik> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/134 X-Sequence-Number: 795 > Sharmad Naik wrote: > > Dear Sir, > I m doing a library management program using Postgresql as backend. We are > given an ISO 2709 format flat file which is only a books dbase which is to be > converted to postgres format > My Q is that where should I import the file ? Please if possible specify > the file or directory where it is to be imported ? Possibly if u have time > please explain me the whole process out of ur time.... Generally, I use the COPY command to import data; see http://www.postgresql.org/users-lounge/docs/7.0/user/c49294939.htm http://www.postgresql.org/users-lounge/docs/7.0/user/sql-copy.htm for documentation on how to use it. I'm involved in a similar library project; would you mind sharing the schema of your database? Much thanks. > Thanks a lot, > > Sharmad -- Max Pyziur BRAMA - Gateway Ukraine pyz@brama.com http://www.brama.com/