[GENERAL] crosstab issue

2016-07-20 Thread Eugenio Trumpy
Hi, I was just tying to perform a crosstab query on pgsql 9.1.4. I wonder if there is something to know for creating a pivot table by using crosstab when the pivot table has more then ten fields. I prepared crosstab query that aggregate less than 10 fields correctly whilst another crosstab qu

[GENERAL] csv import error

2014-09-23 Thread Eugenio Trumpy
Hello, I'm trying to import data using a csv file, but I got an error: ERROR: column "key;daprof;aprof;tipo;valore;note;oid;unit_mis" of relation "assorb" does not exist LINE 1: INSERT INTO "info_pozzi_hydrocarbon"."assorb" ("key;daprof;a...

Re: [GENERAL] csv import error

2014-09-23 Thread Eugenio Trumpy
Behalf Of Eugenio Trumpy Sent: 23 September 2014 11:26 To: pgsql-general@postgresql.org Subject: [GENERAL] csv import error Hello, I'm trying to import data using a csv file, but I got an error: ERROR: column "key;daprof;aprof;tipo;valore;note;oid;unit_mis" of relation &q

Re: [GENERAL] csv import error

2014-09-23 Thread Eugenio Trumpy
rrect. Depending on the size of data in CSV file. Hope this helps. Best Regards Farjad Farid From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Eugenio Trumpy Sent: 23 September 2014 13:14 To: farjad.fa...@checknetworks.com; pgsql-general@postgresq