postgresql - pgadmin import issue? -

-

i trying import following csv file imported pgadmin.

csv file:

"id";"email";"password";"permissions";"activated";"activation_code";"activated_at";"last_login";"persist_code";"reset_password_code";"first_name";"last_name";"created_at";"updated_at" "11";"test.teset@gmail.com";"$2y$10$gnfdfvcgqhqzcgkoilukfeskycupzk1akjvk6pdxt1dmmjoocuypi";"";"t";"xy56hncfheacawzuhleyhvvbxxmoamr57ifyehxiud";"";"2014-05-27 08:47:33";"$2y$10$g0lnastma/kewuhndfwleojqeyo9magvvilfijms/kpripadfbwhm";"";"";"";"2014-05-27 07:51:07";"2014-05-27 08:47:33" "5";"test@gmail.com";"$2y$10$dxodoi520pddcmisxcs/ouih.4k/87lexeqrzvul2k/uth2humpny";"";"t";"4k8s1tbgrpfamcnozvep19moqkcapq0la8bhgkf55a";"";"2014-05-21 21:18:06";"$2y$10$cefsnbqizajbo5pfbmdzkuhzpw17fhqh/frwabmljzjvv0a5vkt1o";"";"";"";"2014-05-21 21:17:45";"2014-05-22 19:12:01"

and command using import csv file,

 drop table users;    create table users (   id serial not null,   email character varying(255) not null,   password character varying(255) not null,   permissions text,   activated boolean not null default true,   activation_code character varying(255),   activated_at timestamp without time zone,   last_login timestamp without time zone,   persist_code character varying(255),   reset_password_code character varying(255),   first_name character varying(255),   last_name character varying(255),   created_at timestamp without time zone,   updated_at timestamp without time zone );   copy users (email,password,permissions,activated,activation_code,activated_at,last_login,persist_code,reset_password_code,first_name,last_name,created_at,updated_at) 'd:/test/db_backup/data_csv.csv'  csv header delimiter ';'         ;

but getting following error, not sure why.

**error: data after last expected column sql state: 22p04**

please let me know issue here?

because have 14 columns of data 13 inside copy statement. specifically, missing id column in copy statment. if data in same order declared in table, there no need put column names in copy table statement.

copy users 'd:/test/db_backup/data_csv.csv'  csv header delimiter ';' null '\n';

will work fine in case -- note don't need either.

edit. need explicitly set null value, in, null '\n'. if use "", can error such as: "csv quote character must not appear in null specification". also, can specify header in csv mode, if want use header, , csv, cannot use "" delimiter, , must use explicit null '\n'.

i have updated original answer include , imported sample data, after replacing "" \n.


Comments

Post a Comment

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more