HomeForum
Welcome, Guest

PostgreSQL Date problem
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: PostgreSQL Date problem

PostgreSQL Date problem 1 year, 2 months ago #1983

  • jonson
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
Hello

I am trying to load data into PostreSQL from fixed width file

Some date fields come empty (for example: order date end and payment date) in some rows.
So, this field must remain empty in the table.

How ever all those records with empty dates are failing to load

What do I have to do?
Thanks,
Boris

Re: PostgreSQL Date problem 1 year, 2 months ago #1984

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Hello

You are not loading empty string you are loading string full of spaces

Try setting "On Error" to null

Please let us know the outcome

John,
www.etl-tools.com

Re: PostgreSQL Date problem 1 year, 2 months ago #1985

  • jonson
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
Thanks for help

It is all working as expected

Boris
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

"We used Advanced ETL Processor to give us more flexibility with business automation. And better yet, we always felt that the DBSL support team is a true partner in every sense of the word, assisting us when we needed help"

Carlos Tantis,
Marketing Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top