[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Importing delimited files
From:       Tom Good <tomg () nrnet ! org>
Date:       1998-06-22 16:07:36
[Download RAW message or body]

On Mon, 22 Jun 1998, kheflin wrote:

> I've usually imported any delimited text files into my PostgreSQL 
> databases using "PGACCESS" which has worked great for me. Our System 
> Admin here is wanting to import a delimited text file into a postgresql 
> database using the psql command line...
> 
> any suggestions?
> 
> Kevin

Hi,

I just finished loading 54,000 + records into postgres, from the command
line.

$ pgsql -e dbname < loadfile

At the top of the file I put;
COPY table_name FROM stdin;

At EOF I put:
\.

BTW, loading 54353 records (22 attributes) into a db took about 4 minutes
on a 486 dx2/66 (all scsi) with a lowly 32M of RAM...

Once I created my index, selecting one record from this soup takes less
than a second (linux 2.0.27)...

Good luck!
===================================================================
		User Guide Dog Database Project
===================================================================
                  Powered by PostgreSQL 6.3.2 
       * Advanced Database Design - Proven Performance *
                             ----
               Perl 5.004 / DBI-0.91::DBD-PG-0.69 
===================================================================
                   http://www.panix.com/~ugd
===================================================================

[prev in list] [next in list] [prev in thread] [next in thread]