Page 1 of 1

pgloader - number of input lines to read

Posted: Thu 14 Apr 2016 07:20
by pkmusthafa
I want to read the fist line from the below data and need to insert in a table using pgloader.
The data is in fixed length flat file.

01000000820160408
0201FLINS
0203CERGY
0204ST-OUEN
0205VILLEROY

I am using the [fixed] section in the conf file for this purpose.
But unable to restrict the number of lines to be read.
1.I tried the option -C <count> in command line - it is throwing the error - "global name 'nb_lines' is not defined"
2.I added the section nb_lines=1 in the conf file, it is still showing "global name 'nb_lines' is not defined".

Please help me to resolve this issue.

Thanks in advance..
Musthafa

Re: pgloader - number of input lines to read

Posted: Thu 14 Apr 2016 07:55
by .jp
Could you please name the Devart tool you are using?

Re: pgloader - number of input lines to read

Posted: Thu 14 Apr 2016 09:37
by pkmusthafa
I am using pgloader to read data from fixed file and to load in postgre sql database.

Re: pgloader - number of input lines to read

Posted: Thu 14 Apr 2016 16:18
by alexa
Unfortunately, we provide technical support only on our products. We would rather recommend you to contact the product's vendor for help on this.

Re: pgloader - number of input lines to read

Posted: Fri 15 Apr 2016 04:25
by pkmusthafa
Thank you for your reply.