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.