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/