From: | Tom Good <tomg(at)nrnet(dot)org> |
---|---|
To: | kheflin <kheflin(at)shreve(dot)net> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] Importing delimited files |
Date: | 1998-06-22 16:07:36 |
Message-ID: | Pine.LNX.3.95.980622120340.13508A-100000@mailhost.nrnet.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
===================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Brian | 1998-06-23 01:45:24 | datatype questions |
Previous Message | Brett W. McCoy | 1998-06-22 15:40:47 | Re: [GENERAL] Importing delimited files |