pgloader - number of input lines to read

pgloader - number of input lines to read

Postby pkmusthafa » Thu 14 Apr 2016 07:20

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
pkmusthafa
 
Posts: 3
Joined: Thu 14 Apr 2016 06:21

Re: pgloader - number of input lines to read

Postby .jp » Thu 14 Apr 2016 07:55

Could you please name the Devart tool you are using?
.jp
Devart Team
 
Posts: 288
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: pgloader - number of input lines to read

Postby pkmusthafa » Thu 14 Apr 2016 09:37

I am using pgloader to read data from fixed file and to load in postgre sql database.
pkmusthafa
 
Posts: 3
Joined: Thu 14 Apr 2016 06:21

Re: pgloader - number of input lines to read

Postby alexa » Thu 14 Apr 2016 16:18

Unfortunately, we provide technical support only on our products. We would rather recommend you to contact the product's vendor for help on this.
alexa
Devart Team
 
Posts: 2087
Joined: Fri 24 Jun 2011 14:17

Re: pgloader - number of input lines to read

Postby pkmusthafa » Fri 15 Apr 2016 04:25

Thank you for your reply.
pkmusthafa
 
Posts: 3
Joined: Thu 14 Apr 2016 06:21


Return to dotConnect for PostgreSQL