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.
>
> T
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 w
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
recogniz
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
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
comp
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 PostgresAp
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
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 d
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 pgs
