Re: [GENERAL] Load Data with COPY
Successfully loaded two files into two different tables. Happy. :-) Diana > Yes, it is a header in the .csv file. I did not know that there is such an > option as specifying WITH HEADER in COPY. > I should have tried to delete the header and specify the loading columns > in the COPY itself. > > Thank you, Adrian, Ray, and John. > > Diana > > >> On 03/24/2015 02:16 PM, Raymond O'Donnell wrote: >>> On 24/03/2015 21:00, dpop...@uvic.ca wrote: I have 7,000+ rows of data in Numbers. Exported to .csv file, tried to > load into postgres table with COPY FROM, failed. Postgres does not > recognize the format: ERROR: invalid input syntax for integer: "project_name,... Is there any way to export/convert the data in Numbers into a format > recognizable by postgres? Mac OS 10.10.6; postgres 9.3.5.2 >>> Well, the error says that you're trying to load a string, >>> "project_name", into an integer column. >>> Is there a header row in the CSV file? - if so, delete it and try > again. >> If it is not a header row issue then it could be the columns in the CSV > file do not match the columns in the table and that data is not matching > what the table column expects. You can specify a column list in the > COPY. >>> Ray. >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To > make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Load Data with COPY
Yes, it is a header in the .csv file. I did not know that there is such an option as specifying WITH HEADER in COPY. I should have tried to delete the header and specify the loading columns in the COPY itself. Thank you, Adrian, Ray, and John. Diana > On 03/24/2015 02:16 PM, Raymond O'Donnell wrote: >> On 24/03/2015 21:00, dpop...@uvic.ca wrote: >>> I have 7,000+ rows of data in Numbers. Exported to .csv file, tried to load into postgres table with COPY FROM, failed. Postgres does not recognize the format: >>> ERROR: invalid input syntax for integer: "project_name,... >>> Is there any way to export/convert the data in Numbers into a format recognizable by postgres? >>> Mac OS 10.10.6; postgres 9.3.5.2 >> Well, the error says that you're trying to load a string, >> "project_name", into an integer column. >> Is there a header row in the CSV file? - if so, delete it and try again. > If it is not a header row issue then it could be the columns in the CSV file do not match the columns in the table and that data is not matching what the table column expects. You can specify a column list in the COPY. >> Ray. > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Load Data with COPY
I have 7,000+ rows of data in Numbers. Exported to .csv file, tried to load into postgres table with COPY FROM, failed. Postgres does not recognize the format: ERROR: invalid input syntax for integer: "project_name,... Is there any way to export/convert the data in Numbers into a format recognizable by postgres? Mac OS 10.10.6; postgres 9.3.5.2 Please, advise. Thank you, Diana -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to get plpython2 in /lib?
Just to let everybody know: happy end! Everything installed and MADlib is successfully registered! Details: 1. Had to use PostgresApp for this installation. No other method worked for my particular case. 2. Had to manually remove several directories and files from my machine, because uninstaller is doing only so much. Was quite a job to find them all! These were 'leftovers' from my previous unsuccessful installations using EnterpriseDB installers (for Postgres and add-ons). HUGE and HEART-FELT thank you for Adrian Klaver and Jacob Egger, for support! Diana > On 03/07/2015 10:09 AM, dpop...@uvic.ca wrote: >> Thank you so much, Adrian! You are most helpful. :-) >> >> I was up at 2 a.m. worrying about my project (just 2 weeks to complete), >> and by 10 a.m., after installing/uninstalling several times, started >> questioning everything. >> I needed a calm voice like yours to tell me that I might be weird, but >> not >> completely insane. > > Noticed the UVIC email. FYI, there will be a Postgres mini-conference at > LFNW(http://linuxfestnorthwest.org) April 25th & 26th in Bellingham if > you want to talk to some Postgres experts even after the project is done. > >> >> Thank you, >> >> Diana >> > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to get plpython2 in /lib?
Thank you so much, Adrian! You are most helpful. :-) I was up at 2 a.m. worrying about my project (just 2 weeks to complete), and by 10 a.m., after installing/uninstalling several times, started questioning everything. I needed a calm voice like yours to tell me that I might be weird, but not completely insane. Thank you, Diana > On 03/07/2015 09:52 AM, dpop...@uvic.ca wrote: >> Adrian, >> >> I again wiped out everything postgres from my machine (Mac 10.10.2, >> Yosemite). Now, if I want to start installing postgres 9.3 anew, what is >> the best way to go for it? > > Aah, you anticipated the post I just sent. > >> I found PostgresApp, that promises the easiest way to start using >> postgres. Does it mean that if I install this PostgresApp for 9.3 (click >> on the link), it will install and run postgres 9.3? > > Yes: > > http://postgresapp.com/documentation/install.html > > "To install Postgres.app, just drag it to your Applications folder and > double click. > > On first launch, Postgres will initialise a new database cluster and > create a database for your username. A few moments after launching, you > should be able to click on "Open psql" to connect to the database. > > If you'd like to use the command line tools delivered with Postgres.app, > see the section on Command Line Tools." > >> Or I must first install postgres 9.3 by other means and only after that >> I >> can use PostgresApp for an easier access to postgres? > > No. >> >> Confused, >> >> Diana >> >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to get plpython2 in /lib?
Adrian, I again wiped out everything postgres from my machine (Mac 10.10.2, Yosemite). Now, if I want to start installing postgres 9.3 anew, what is the best way to go for it? I found PostgresApp, that promises the easiest way to start using postgres. Does it mean that if I install this PostgresApp for 9.3 (click on the link), it will install and run postgres 9.3? Or I must first install postgres 9.3 by other means and only after that I can use PostgresApp for an easier access to postgres? Confused, Diana > Thank you, Adrian. > Maybe, you will be able to find something useful. > I spent more hours trying to > - install PostgreSQL 9.3 (successful, but with python3) > - install PostgresApp 9.3 (unsuccessful, could not start postgres, but no > matter - no python2 there anyway), then uninstall it. > - install Python 2.7 (successful) > > MADlib still cannot be registered - same failure, with no plpython2 found > in /lib: > > madpack.py : INFO : Testing PL/Python environment... > madpack.py : INFO : > Creating language PL/Python... > madpack.py : ERROR : SQL command failed: > SQL: CREATE LANGUAGE plpythonu; > ERROR: could not access file "$libdir/plpython2": No such file or > directory > > madpack.py : ERROR : Cannot create language plpythonu. Stopping > installation... > madpack.py : ERROR : MADlib installation failed. > > Sad, :-( > > Diana > >> On 03/06/2015 05:41 PM, dpop...@uvic.ca wrote: >>> Postgres installed with Installer, from EnterpriseDB. >>> Error received while trying to register MADlib 1.7.0. >> >> I seem to remember the EDB builds against Python 3 not 2 now, which >> would explain the error below if MADlib is looking for Python 2. I >> cannot remember if there is a work around, will dig into further. >> >>> >>> Looked at PostgresApp, but it is a package for PostgreSQL 9.4. Cannot >>> have >>> this version of Postgres, because it is not supported by MADlib. Tried, >>> does not work. Had to uninstall, + manual deletion of a number of >>> 'leftovers'. :-( >> >> According to here: >> >> https://github.com/madlib/madlib/wiki/Installation-Guide >> >> it should work with 9.2+. >> >> >> There is 9.3 version of PostgresApp available here: >> >> https://github.com/PostgresApp/PostgresApp/releases >> >>> >>> Need MADlib for research. Please, help. >>> >>> Diana >>> >>> On 03/06/2015 12:44 PM, dpop...@uvic.ca wrote: > Mac 10.10.2 (Yosemite) > PostgreSQL 9.3 > > error message: > ERROR : SQL command failed: SQL: CREATE LANGUAGE plpythonu; > ERROR: could not access file "$libdir/plpython2": No such file or > directory > > Searched Web, nothing useful found... > > Any advice will be greatly appreciated. How was Postgres installed? What where you doing to get the error? Doing a pg_restore from another database? Running CREATE LANGUAGE/EXTENSION directly? > > Diana > > > -- Adrian Klaver adrian.kla...@aklaver.com >>> >>> >>> >>> >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to get plpython2 in /lib?
Thank you, Adrian. Maybe, you will be able to find something useful. I spent more hours trying to - install PostgreSQL 9.3 (successful, but with python3) - install PostgresApp 9.3 (unsuccessful, could not start postgres, but no matter - no python2 there anyway), then uninstall it. - install Python 2.7 (successful) MADlib still cannot be registered - same failure, with no plpython2 found in /lib: madpack.py : INFO : Testing PL/Python environment... madpack.py : INFO : > Creating language PL/Python... madpack.py : ERROR : SQL command failed: SQL: CREATE LANGUAGE plpythonu; ERROR: could not access file "$libdir/plpython2": No such file or directory madpack.py : ERROR : Cannot create language plpythonu. Stopping installation... madpack.py : ERROR : MADlib installation failed. Sad, :-( Diana > On 03/06/2015 05:41 PM, dpop...@uvic.ca wrote: >> Postgres installed with Installer, from EnterpriseDB. >> Error received while trying to register MADlib 1.7.0. > > I seem to remember the EDB builds against Python 3 not 2 now, which > would explain the error below if MADlib is looking for Python 2. I > cannot remember if there is a work around, will dig into further. > >> >> Looked at PostgresApp, but it is a package for PostgreSQL 9.4. Cannot >> have >> this version of Postgres, because it is not supported by MADlib. Tried, >> does not work. Had to uninstall, + manual deletion of a number of >> 'leftovers'. :-( > > According to here: > > https://github.com/madlib/madlib/wiki/Installation-Guide > > it should work with 9.2+. > > > There is 9.3 version of PostgresApp available here: > > https://github.com/PostgresApp/PostgresApp/releases > >> >> Need MADlib for research. Please, help. >> >> Diana >> >> >>> On 03/06/2015 12:44 PM, dpop...@uvic.ca wrote: Mac 10.10.2 (Yosemite) PostgreSQL 9.3 error message: ERROR : SQL command failed: SQL: CREATE LANGUAGE plpythonu; ERROR: could not access file "$libdir/plpython2": No such file or directory Searched Web, nothing useful found... Any advice will be greatly appreciated. >>> >>> How was Postgres installed? >>> >>> What where you doing to get the error? >>> Doing a pg_restore from another database? >>> Running CREATE LANGUAGE/EXTENSION directly? >>> >>> Diana >>> >>> >>> -- >>> Adrian Klaver >>> adrian.kla...@aklaver.com >>> >> >> >> >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to get plpython2 in /lib?
Postgres installed with Installer, from EnterpriseDB. Error received while trying to register MADlib 1.7.0. Looked at PostgresApp, but it is a package for PostgreSQL 9.4. Cannot have this version of Postgres, because it is not supported by MADlib. Tried, does not work. Had to uninstall, + manual deletion of a number of 'leftovers'. :-( Need MADlib for research. Please, help. Diana > On 03/06/2015 12:44 PM, dpop...@uvic.ca wrote: >> Mac 10.10.2 (Yosemite) >> PostgreSQL 9.3 >> >> error message: >> ERROR : SQL command failed: SQL: CREATE LANGUAGE plpythonu; >> ERROR: could not access file "$libdir/plpython2": No such file or >> directory >> >> Searched Web, nothing useful found... >> >> Any advice will be greatly appreciated. > > How was Postgres installed? > > What where you doing to get the error? > Doing a pg_restore from another database? > Running CREATE LANGUAGE/EXTENSION directly? > > >> >> Diana >> >> >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] How to get plpython2 in /lib?
Mac 10.10.2 (Yosemite) PostgreSQL 9.3 error message: ERROR : SQL command failed: SQL: CREATE LANGUAGE plpythonu; ERROR: could not access file "$libdir/plpython2": No such file or directory Searched Web, nothing useful found... Any advice will be greatly appreciated. Diana -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
