Export table to sql inserts does not check for foreign keys to self

Invincible

Member²
I have have a table with foreign key to itself but when I export it to sql inserts they are not ordered to satisfy the foreign key.
 
Data for self-referencing foreign keys are indeed not sorted. When using the export function you can use the "Disable foreign key constraints" option instead. In the resulting export file they will be disabled before inserting the records and enabled again afterwards.
 
Hi, Thanks it works very well.
Is there an option to add N before strings, I want to export unicode strings to N'' format insted of '' f

I found workaround export/import using pl/slq format
 
Last edited:
Back
Top