Let's assume you have a CSV file which looks like this:
$ head -5 /tmp/prod.csv 1,14,ACADEMY ACADEMY,PENELOPE GUINESS,25.99,0,1976 2,6,ACADEMY ACE,EWAN RICKMAN,20.99,0,6289 3,6,ACADEMY ADAPTATION,VIVIEN KAHN,28.99,0,7173 4,3,ACADEMY AFFAIR,ALAN MARX,14.99,0,8042 5,3,ACADEMY AFRICAN,CARRIE HANNAH,11.99,1,2183
Recently I needed to put together some simple design diagrams in a hurry and it occurred to me that pgAdmin's Graphical Query Builder would be just the thing. Admittedly its layout functionality is limited to creating boxes with tablename and columns, and drawing lines without fancy arrows between columns on different tables, but it's enough to sketch out basic entity relationships.
January 18th (Saturday): 3rd PostgreSQL Unconference@Tokyo
|Time:||13:30 ~ 17:30|
|Location:||Asushisuto Seminar Room, 4-2-1 Kudanshita-kita, Chiyoda-ku (東京都千代田区九段北4-2-1) (map)|
Informal "unconference" event with no fixed agenda. Presentations mainly in Japanese, but English-speakers (and speakers in English) more than welcome. Unfortunately I won't be able to attend this time :(
February 1st (Saturday): 28th PostgreSQL Study Group
|Time:||13:00 ~ 17:30|
|Location:||AIIT Satellite Campus, 1-18-13 Soto-kanda, Chiyoda-ku (map)|
- SAWADA Masahiko: Understanding the VACUUM source code
- HAYAMIZU Yuto: Performance Measurements Pt. II - Practical Session
- NAKANISHI Yoshinori: Monitoring PostgreSQL with Zabbix
(subject titles are my own translation)
PostgreSQL specialist wanted
While I'm at it, my employer is actively seeking a PostgreSQL specialist to assist with various database migration projects in the financial sector. Finance experience welcome but not necessary; reasonable competence in spoken/written Japanese preferred. Details here.
Well I've finally fulfilled one of my 2013 New Year's resolutions, which was to write some kind of foreign data wrapper, so with no further ado here is the initial implementation. It is basically working but is still very much in the proof-of-concept/unstable/may-eat-your-data stage. Having said that, if anyone has a practical use for this I'd be very interested to hear about it - my main motivation for creating this FDW is to learn more about PostgreSQL internals.