Skip site navigation (1) Skip section navigation (2)

IMPORT or ETL tools

From: Louie Kwan <lkwan(at)nuvo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: IMPORT or ETL tools
Date: 2004-03-11 21:25:32
Message-ID: FB4FDC17A002D711BC0C009027DE84AF027F6C2E@EXCHANGE.nuvo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi All,

Do anyone of you aware of any good PG import tool same as SQL*LOADER in
ORACLE

We are doing some DataWarehouse work and need to import a large set of data
from csv files.

We are trying a import tool from ems-hitech.com, but I have troubles when
loading time and date columns.

Any help is much appreciated.

Thanks
Louie

------ |  Creating NNM_HOST Table
------ |

CREATE TABLE NNM_NODES (
 lastLoadTime_e       DATE,
 domain_name          VARCHAR(10),
 ----
 ovtopo_id            INTEGER   NOT NULL,
 node_type            VARCHAR(10),
 node_name            VARCHAR(30),
 ov_status            VARCHAR(10),
 ipaddress            VARCHAR(15)
);
data.csv
--------
31/01/2004,D1H01,845,IP,dfrQCQCRD1,Normal,142.130.35.1
31/01/2004,D1H01,849,IP,dfrQCIMCP1,Normal,142.130.130.33
31/01/2004,D1H01,853,IP,dfrQCSIBL1,Normal,142.130.130.19


Responses

pgsql-admin by date

Next:From: Greg SpiegelbergDate: 2004-03-11 21:37:25
Subject: Re: IMPORT or ETL tools
Previous:From: Nick Fankhauser - DoxpopDate: 2004-03-11 20:53:23
Subject: using disable-triggers in pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group