Copy NULL in PostgreSQL database -


i trying copy csv file postgres 9.5.3 , running issues null. file encoded in ascii, client_encoding utf-8, , server encoding utf-8. null in quoted string shown below.

enter image description here

i error 

error:  invalid byte sequence encoding "utf8": 0x00 context:  copy test_null, line 1 ********** error **********  error: invalid byte sequence encoding "utf8": 0x00 sql state: 22021 context: copy test_null, line 1

my table structure 

create table test_null(nullcolumn char(10));  copy test_null 'f:\user area\dcs.txt' csv  null 'null';

i have tried escaping specifying "\", , tried other options of copy command, nothing seems work. not sure, how process this.

your file contains ascii 0 characters, rejected postgresql.

you'll have use other representation null values if want load them database copy.


-

Comments

Post a Comment

Popular posts from this blog

c# - ajax - How to receive data both html and json from server? -

i have referenced this topic , doesn't solve problem. i'm using mvc 5 c#. have used code receive data server data type json . $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "json", success: function (data) { if (data.result) { alert('successfull'); } else { alert(data.ex); } } }); and controller code: [httppost] public actionresult myaction() { try { return json(new { result = "true", ex = "" }); } catch (exception e) { return json(new { result = "false", ex = e.message }); } } i use way data type html: $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "html", success: function (data) { $(".mydiv").append(data); } }); and controller should be: [httppost] public actionresult myaction() { return partialview("_...
Read more

swift - Button on Table View Cell connected to local function -

i have table view cell loaded data parse request. loads "friend requests", showing requesting friends name , 2 buttons, "accept" , "reject" here cellforrowatindexpath func: func tableview(tableview: uitableview, cellforrowatindexpath indexpath: nsindexpath) -> uitableviewcell { let cell:notifications_jlr_cell = self.tableview.dequeuereusablecellwithidentifier("cell") as! notifications_jlr_cell cell.txtrequestdesc.text = searchresults[indexpath.row].requesteename + " has requested friend" cell.btnapprove_outlet.addtarget(self, action:selector("approve"), forcontrolevents: uicontrolevents.touchupinside) return cell } the table loads fine, , addtarget line, once "approve" button clicked, runs func: func approve() { println("approve") } however, when fetching parse data, have set in array, objectid friend request, want refer in approve() function how can pass objectid ...
Read more