[SQL] sqlloader features

Hi ,    does postgresql support for the sql loader functionality like oracle does ??? if no, is there any tools specific to do this task connect to postgresql database??? i'm looking into open-source tools that can do import & export facility. thanks in advance

Re: [SQL] designer tool connect to PostgreSQL

Hi,   thanks to all for the responnd...i've look into all the tools mentioned and found many tools which has a great feautre such as designing/modelling the object/table but it seems look like that there is no tools that can do the ETL process. thanks in advance Rich Hall <[EMAIL PROTECTE

[SQL] Database reporting tool

Hi,   i'm using PostgreSQL as my database and now i'm looking for a good reporting tools(can do ad-hoc queries & ease of use)  that can connect to several database instead of PostgreSQL. thanks in advance

Re: [SQL] pg_hba.conf

Hi,    by the way i've settle my connection problem between client application and server itself . this is happen because of editing the parameter in pg_hba.conf while the environment(database was running) was active.  tq [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12:12 PM Today  

[SQL] pg_hba.conf

Hi, i try to connect to my database as $ psql dwnc biosadm but got the error "psql: FATAL: No pg_hba.conf entry for host localhost, user biosadm, database dwnc" Below are the detail in pg_hba.conf # TYPE DATABASEUSERIP-ADDRESSIP-MASK METHOD local

[SQL] designer tool connect to PostgreSQL

Hi, i use postgresql as my database. does anyone know the designer tool that can connect to postgeSQL ??? meaning to say the tools can handle design task like create table , etc . appreciate if u can give the specific URL. thanks in advance.

Re: [SQL] time series data

Hi,   thanks for the feedback. btw i've run the statement below  & got the following result :     time_key | yr_id | month_id | month_desc | day_id               --+---+--++                       193 |  1994 |               7 |             jul        |  

Re: [SQL] time series data

Hi,    thanks for the info..btw can u pls explain a little bit detail since i can't get thru yr solution. thanks in advance Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał: > Use this integer sequence and interval datatype to get date result: > your_date='1994-01-01'::date+'1 day'::i

[SQL] time series data

Hi,     i want to create time table  & the structure as below :                 Column  Type  Modifiers time_key yr_id month_id month_desc day_id  integer  integer  integer  text  integer  not null default nextval('time_seq'::text) Example of data in time table: Time_key  yr_id   mon

Re: [SQL] Insert into:Bad date external representation

Hi,  got an error as below :    dwnc=> insert into biosadm.custdo_dim dwnc->  (do_key,do_no,do_date,attnto,custlo) dwnc->  select nextval('cdo_seq'),c.dono::varchar,c.dodate::date, dwnc-> c.attnto, c.custlo  from custdo_temp c; ERROR:  Bad date external representation '' Table structure (cu

[SQL] Insert into

Hi,   i've structure table like below and want to load data from temp table into table below :     dwnc=> \d cust_lo_dim                           Table "biosadm.cust_lo_dim"   Column   |         Type          |                 Modifiers ---+---+--

Re: [SQL] Missing data for column

Hi,  Sorry for the late respond. i've solved my problem. the error comes out when the data has subsidiary column but there is no subsidiary column in table. tq Michael Glaesemann <[EMAIL PROTECTED]> 01/09/2004 06:54 PM ZE9         To:        [EMAIL PROTECTED]         cc:        [EM

[SQL] Missing data for column

Hi, i got an error below after running copy command . the table structure as following :           Table "biosadm.custinv_temp    Column    |     Type      | -+---+-  yr          | integer       |  custname    | text          |  invstatus   | text          |  custlo    

Re: [SQL] COPY command

Hi , yes now i can do the copy after replace comma delimiter with tab delimiter which is default copy with delimiter . btw  i've another question : how do we run the COPY command from file which has several null columns in each field.   thanks. example :    dwnc=# copy biosadm.custinv_te

[SQL] data loading

Hi,   i try to load data from flat file (comma delimiter format) into temporary table . i use COPY command as below: dwnc=# copy biosadm.custdo_temp dwnc-# from '/home/bios/customer_data/CustomerDO_new.CSV' dwnc-# WITH DELIMITER ',' ; ERROR:  copy: line 141, Extra data after last expected

[SQL] COPY command

Hi, i try to load a file into temporary table but it gives me an error . do u have any idea/solutions ?? the command that i've running as below : dwnc=# copy biosadm.custdo_temp dwnc-# from '/home/bios/customer_data/CustomerDO_new.CSV' dwnc-# WITH DELIMITER ',' ; ERROR: copy: line 14

[SQL] COPY command

Hi,   i try to load a file into temporary table but it gives me an error . do u have any idea/solutions ??  the command that i've running as below :     dwnc=# copy biosadm.custdo_temp dwnc-# from '/home/bios/customer_data/CustomerDO_new.CSV' dwnc-# WITH DELIMITER ',' ; ERROR:  copy: line 1