Changed the management of NULLs

2 files changed, 5 insertions, 5 deletions

diff --git a/sqlplain/mssql_util.py b/sqlplain/mssql_util.py
index c3617c6..c4603e7 100644
--- a/sqlplain/mssql_util.py
+++ b/sqlplain/mssql_util.py
@@ -64,7 +64,7 @@ def get_source_mssql(conn, objname):
     "Extracts the source code for views and procedures"
     return conn.execute(GET_DEF, (objname,), scalar=True)
 
-def dump_file_mssql(uri, table_or_query, fname, mode, sep='\t', null='\N'):
+def dump_file_mssql(uri, table_or_query, fname, mode, sep='\t', null=''):
     """
     Dump a table or query into a CSV file by using bcp. Examples:
     >> dump_file(conn, 'client.csv', 'client', sep='\t')
diff --git a/sqlplain/postgres_util.py b/sqlplain/postgres_util.py
index 02e931d..b83bc1c 100644
--- a/sqlplain/postgres_util.py
+++ b/sqlplain/postgres_util.py
@@ -45,8 +45,8 @@ def exists_db_postgres(uri):
             return True
     return False
 
-def dump_file_postgres(uri, query, filename, mode, sep='\t', null='\N',
-                       schema=None):
+def dump_file_postgres(uri, query, filename, mode, sep='\t', null='',
+                       schema=None): # or null='\N'
     """
     Save the result of a query on a local file by using COPY TO and psql
     """
@@ -62,8 +62,8 @@ def dump_file_postgres(uri, query, filename, mode, sep='\t', null='\N',
             (query, sep, null), filename, schema)
 
 # apparently copy_from from psycopg2 is buggy for large files
-def load_file_postgres(uri, tname, filename, mode, sep='\t', null='\N',
-                       schema=None):
+def load_file_postgres(uri, tname, filename, mode, sep='\t', null='',
+                       schema=None): # or null='\N'
     """
     Load a file into a table by using COPY FROM and psql
     """