Hi, I want to convert my database in FoxPro to PostgreSQL but I have a
big problem. Original database in FoxPro (dbc) using empty date but I
can't convert empty date to null because this column has properties not
null. PostgreSQL doesn't supported empty field. What should I do?

matius wrote:

Technically there is nothing you can do. There is no "empty" date value in
postgres, you have to use null.

If you are not in control of this database, ask the person who put in the
NOT NULL rule what they would like you to do. If they are not around
anymore, ask their boss. If nobody knows, examine what would happen if you
removed the NOT NULL rule.

--
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)