pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Louie Kwan <lkwan@nuvo.com>
To: pgsql-admin@postgresql.org
Subject: IMPORT or ETL tools
Date: Thu, 11 Mar 2004 16:25:32 -0500
Message-ID: <FB4FDC17A002D711BC0C009027DE84AF027F6C2E@EXCHANGE.nuvo.com> (raw)

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




view thread (2+ messages)  latest in thread

Message-ID: <FB4FDC17A002D711BC0C009027DE84AF027F6C2E@EXCHANGE.nuvo.com>
Permalink:  ../FB4FDC17A002D711BC0C009027DE84AF027F6C2E@EXCHANGE.nuvo.com/
Also on:    postgresql.org/message-id/FB4FDC17A002D711BC0C009027DE84AF027F6C2E@EXCHANGE.nuvo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: lkwan@nuvo.com
  Subject: Re: IMPORT or ETL tools
  In-Reply-To: <FB4FDC17A002D711BC0C009027DE84AF027F6C2E@EXCHANGE.nuvo.com>
  References: <FB4FDC17A002D711BC0C009027DE84AF027F6C2E@EXCHANGE.nuvo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox