return null as \N from psql I'm trying to migrate some data from postgres to mysql. for that i'm doing a simple sql in postgres and load it to mysql. since format is a bit different the flag -AF $'\t' in psql makes it tab delimiter which is great.
The missing part is that psql return null as empty string. where in mysql it represent as \N.
Is there a flag that manage it? I would really like to avoid putting ifnull around each column in the select.
psql has a flag that controls the way null is outputted -P 'null=\N'