pgloader - number of input lines to read

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
pkmusthafa
Posts: 3
Joined: Thu 14 Apr 2016 06:21

pgloader - number of input lines to read

Post by 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

.jp
Devart Team
Posts: 303
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: pgloader - number of input lines to read

Post by .jp » Thu 14 Apr 2016 07:55

Could you please name the Devart tool you are using?

pkmusthafa
Posts: 3
Joined: Thu 14 Apr 2016 06:21

Re: pgloader - number of input lines to read

Post by pkmusthafa » Thu 14 Apr 2016 09:37

I am using pgloader to read data from fixed file and to load in postgre sql database.

alexa
Devart Team
Posts: 2279
Joined: Fri 24 Jun 2011 14:17

Re: pgloader - number of input lines to read

Post by 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.

pkmusthafa
Posts: 3
Joined: Thu 14 Apr 2016 06:21

Re: pgloader - number of input lines to read

Post by pkmusthafa » Fri 15 Apr 2016 04:25

Thank you for your reply.

Post Reply