[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

[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
] On 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 assorb does not existLINE

Re: [GENERAL] csv import error

2014-09-23 Thread Eugenio Trumpy
. 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@postgresql.org