leodo@blog

%MySQL%/bin
mysqldump $DATABASE_NAME -v -nt --compatible=ansi,postgresql --complete-insert=TRUE --extended-insert=FALSE --compact --default-character-set=UTF8 -u $DATABASE_USER -p -r $OUTPUT_FILE

%Postgresql%/bin
psql -d $DATABASE_NAME -f $OUTPUT_FILE -U user_name -W

這期有報名陳春隆老師在中正社大開的攝影班。班上同學很多都可以拍出很有意境的作品了，我根本是幼幼組越級參加進階班，鼓起勇氣把自己作品拿出來在班上檢討，被老師批地…很愉悅！有好的老師幫忙作品檢討超有感覺的～哈！
...繼續閱讀

雖說天氣不好也有天氣不好的拍法，
不過還是很不會抓這種紀錄漁村式的手法 & 小品照片攝影眼 Q.Q
找不到一張比較滿意的。

...繼續閱讀

:::可以解決在Windows環境下中文編碼的問題::::

1. 將*.shp檔轉為文字檔
　shp2pgsql db.shp public.table -> db.sql
2. 用記事本另存 db.sql 為 UTF-8 Encoding
3. 刪除db.sql中異常字元(e.g. \ )
4. psql -d database_name -f db.sql -U user_name -W

Reference: First they came

When the Nazis came for the communists,
I remained silent;
I was not a communist.

When they locked up the social democrats,
I remained silent;
I was not a social democrat.

When they came for the trade unionists,
I did not speak out;
I was not a trade unionist.

When they came for the Jews,
I remained silent;
I was not a Jew.

When they came for me,
there was no one left to speak out.


極權統治就是當大家都對極權麻痺、政治冷漠的時候。