Postgresql - inserting blank into timestamp field

Question

I am trying to insert a blank into a timestamp field. In the table, it is defined as updt_ts timestamp NULL. But, I am still getting the below error:

ERROR:  invalid input syntax for type timestamp: ""
CONTEXT:  COPY dt_acct_stat_dim, line 1, column updt_ts: ""

Any fix for this error?

When you say "blank", do you mean NULL, or an empty string? Because for a field of type TIMESTAMP, the first should work (if the field is nullable), but the second won't. Are you running this query manually, or getting the input from somewhere (that might be sending empty string)? — Zack
– Zack, Commented Jul 25, 2018 at 14:21
Show us your insert statement. But try INSERT VALUES(id, NULL) instead of INSERT VALUES(id, '') — Juan Carlos Oropeza
– Juan Carlos Oropeza, Commented Jul 25, 2018 at 14:24

Scoots · Accepted Answer · 2018-07-25 15:41:26Z

1

By your error message, you're using the copy command.

When using the copy command, one of the options available to you is to specify a null string:

copy
    table_name
from
    '/my/file.csv'
with (
    format csv,
    null ''
);

Full docs

answered Jul 25, 2018 at 15:41

Scoots

3,1142 gold badges25 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql - inserting blank into timestamp field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related