What is the proper syntax for using the DISABLE_FK_CHECK option of the COPY command?

Viewed 51

How do we use the DISABLE_FK_CHECK option in the COPY command?

This does not work:

yugabyte=> \COPY xpctd_prtn_value FROM '/root/data.txt' WITH (FORMAT CSV, DELIMITER '|', DISABLE_FK_CHECK);
ERROR:  option "disable_fk_check" not recognized
LINE 1: ...value FROM STDIN WITH (FORMAT CSV, DELIMITER '|', DISABLE_FK...
                                                             ^

See doc page for reference.

I am running:

yugabyte=> SELECT substring(version() from 'YB-([^\s]+)') AS "YugabyteDB Version";
 YugabyteDB Version
--------------------
 2.13.2.0-b0
(1 row)

Thanks!

1 Answers
Related