| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Xinyu Hua <xhua(at)cse(dot)ucsc(dot)edu> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org, pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Re: [INTERFACES] load database from ascii files |
| Date: | 2003-08-01 16:48:46 |
| Message-ID: | 1059756526.22273.1635.camel@camel |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-cygwin pgsql-interfaces |
On Fri, 2003-08-01 at 00:26, Xinyu Hua wrote:
> Hi,all
> I used the TPC-H database population tool DBgen and generated some ascii
> files contain pipe-delimited load data for tables. How may I get these
> data loaded to tables and create database in postgresql?
> Thanks in advance.
> Xinyu
>
If you have the tables created, I think you only need to do
COPY table FROM 'filename' WITH DELIMITER '|'
from inside psql and that should work.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | markw | 2003-08-01 20:51:54 | Re: [INTERFACES] load database from ascii files |
| Previous Message | Jason Tishler | 2003-08-01 13:44:12 | Re: Can't find the .README file |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | markw | 2003-08-01 20:51:54 | Re: [INTERFACES] load database from ascii files |
| Previous Message | Patricia Macary | 2003-08-01 14:53:16 | PGaccess can't find 'oids' |