PostgreSQL 썸네일형 리스트형 postgresql backup Database 목록 보기 $ /usr/local/pgsql/bin/psql -l List of databases Name | Owner | Encoding ----------------+----------------+----------- xxx | xxx | SQL_ASCII yyy | yyy | UTF8 (2 rows) Database Backup $ /usr/local/pgsql/bin/pg_dump xxx> xxx.dump 특정 table만 Backup $ /usr/local/pgsql/bin/pg_dump --table=table1 some_db > table_dump $ /usr/local/pgsql/bin/pg_dump -Uxxx --no-owner --no-privileges --table.. 더보기 디비 언어설정때문에 한글정렬이 안될경우 Built-in Conversions Conversion Name [a] Source Encoding Destination Encoding ascii_to_mic SQL_ASCII MULE_INTERNAL ascii_to_utf_8 SQL_ASCII UNICODE big5_to_euc_tw BIG5 EUC_TW big5_to_mic BIG5 MULE_INTERNAL big5_to_utf_8 BIG5 UNICODE euc_cn_to_mic EUC_CN MULE_INTERNAL euc_cn_to_utf_8 EUC_CN UNICODE euc_jp_to_mic EUC_JP MULE_INTERNAL euc_jp_to_sjis EUC_JP SJIS euc_jp_to_utf_8 EUC_JP UNICODE euc_kr.. 더보기 이전 1 다음