Cool! It might be easier to discover and use than IRC... we'll see what happens
Hi Guys, i have a question, i'm trying to migrate sqlite db into postgresdb, pgloader seems to be the only tools that could do proper conversion
i'm creating a command script to migrate, but i wonder how can i make it only transfer data ?
I would like to remove such calls ideally: drop cascades to constraint changeset_comments_pull_request_id_fkey on table changeset_comments
ok, so create no indexes seems to do what i wanted
Hi, happy you did find it!
hi! Tring to use csv loading, but cant get timestamps to work. I've defined ts as => ts[ date format 'YYYYMMDDHH24MI']
csv looks like this 1;201510101010
Im getting an error saying; invalid input syntax for type timestamp: "2015--1-0- 10: 1:NIL"
with current git master code I have "2015-10-10 10:10:NIL"
fixing that to be "2015-10-10 10:10:00" instead (defaulting non-provided parts from the format string to 00 in the time parts, so that you can ignore seconds here)
see dimitri/pgloader@da05782 for your problem case and please recompile from a fresh git clone, you should be good then
Aah, ok. thanks!
Hi guys - I am looking to modify the batch options in my config file, but I am having a hard time figuring out where I need to put that, and what the syntax is. From what I gathered from looking at the source it should simply be a matter of putting "batch size = 10000" somewhere.
oh you tried here first... well twitter is good too I guess
Hello guys, we are intending to use the pgloader as a helping tool for our Snow Plow implementation. The problem is that as far as I can see, pgloader still does not support JSON load, is that correct ?
Hello Guys, Good day..I am facing a issues using pgloader configuration file...We are using external file to load data to postgresql database using pgloader..After insert , some of the data's are not inserted as expected null (source has null or blank space)..can you help me how to mention null if blanks on configuration file or any possible way to fix
@mcapanema : can you detail your JSON use case a bit please?