Postgres has the same type of ability MySQL has to read in files, yet much nicer syntax. LOAD DATA INFILE from MySQL is just COPY in postgres. I decided to try having it read from a named pipe today, and it worked out nicely.
I’ve been at OSCON 2008, and I’ve been keeping pretty good notes on the tutorials I’ve attended. GitHub has a great feature if you take notes in rdoc, making nice HTML when it’s viewed online. Here’s some links to my notes: Pro PostgreSQL This talk was alright, but it wasn’t really tailored for people who hadn’t used Postgres extensively. Yet, I’m sure the notes will come in handy in the future. Introduction to Django This was an awesome talk. He [...]
I had some trouble compiling PL/Ruby for PostgreSQL today on Modzer0. I solved it with some clever extconf.rb switches: ruby extconf.rb –with-pgsql-include=/usr/include/pgsql/ –with-pgsql-version=81 Now I avoid the problems I was having before: [root@modzer0 plruby-0.5.1]# make make[1]: Entering directory #… In function ‘perm_fmgr_info’:plruby.c:116: error: ‘TopMemoryContext’ undeclared (first use in this function) plruby.c:116: error: (Each undeclared identifier is reported only once plruby.c:116: error: for each function it appears in.) plruby.c: In function ‘plruby_call_handler’: plruby.c:706: warning: unused variable ‘result’ plruby.c: In function ‘pl_compile’: [...]
FeedBurner
License
