or when you have tab delimited files, you can use
the 'copy' command of postgresql:
template1=# \help copy
Command: COPY
Description: Copies data between files and tables
Syntax:
COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]
COPY [ BINARY ] table [ WITH OIDS ]
TO { 'filename' | stdout }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]
template1=# copy table1 from 'foo.txt';
--
:: Sergio A. Kessler ::
Linux user #64005 - http://counter.li.org
----- Original Message -----
From: "Dieter Simader" <[EMAIL PROTECTED]>
> You could dump the dbf files into tab delimited files and then use cut,
> paste and awk to put together insert strings.
>
>
> Dieter Simader http://www.sql-ledger.org (780) 472-8161
> DWS Systems Inc. Accounting Software Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
>
> On Tue, 15 Oct 2002, Jon Postyn wrote:
>
> >
> >
> > Jon Postyn
> > JLP Computer Enterprises Corp
> > 70-09 Austin Street
> > Suite 202
> > Forest Hills, NY 11375
> > voice: 718-575-9219
> > fax: 718-575-3622
> > http://www.jlpcomputer.com
> >
>
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: viaVerio will pay you up to
> $1,000 for every account that you consolidate with us.
> http://ad.doubleclick.net/clk;4749864;7604308;v?
> http://www.viaverio.com/consolidator/osdn.cfm
> -------------------------------------------------------
> (un)subscribe:
http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> Archive: http://www.mail-archive.com/sql-ledger-users@;sql-ledger.org/
>
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
-------------------------------------------------------
(un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
Archive: http://www.mail-archive.com/sql-ledger-users@;sql-ledger.org/
