Issues: Using simple COPY command with out passing datatimeformat will cause wrong number of records.
Command: Use COPY command by passing datetimeformat
COPY table_name TO '/path/to/save/file.csv' with DATETIMEFORMAT = '%Y-%m-%d %H:%M:%S.%f%z';
Note: The timestamp uses strftime format.
***
No comments:
Post a Comment