Lecture/PostgreSQL3 pgsql utf8 디비 생성시 오류 실행CREATE DATABASE coupon WITH OWNER = malluser ENCODING = 'UTF8' CONNECTION LIMIT = -1; 오류ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (EUC_KR)HINT: Use the same encoding as in the template database, or use template0 as template. 해결Ok, below steps resolved the problem:First, we need to drop template1. Templates can’t be dropped, so we first modify it so t.. 2014. 7. 31. PGSQL 자료형 SchemaNameInternal nameSizeDescriptionpg_catalog"any"any4pg_catalog"char"char1single characterpg_catalogabstimeabstime4absolute, limited-range date and time (Unix system time)pg_catalogaclitemaclitem12access control listpg_cataloganyarrayanyarrayvarpg_cataloganyelementanyelement4pg_cataloganyenumanyenum4pg_cataloganynonarrayanynonarray4pg_catalogbigintint88~18 digit integer, 8-byte storagepg_cat.. 2012. 12. 4. PGSQL 기본 ( 계속 추가 예정 ) ■ 계정생성create user 계졍명 with password '패스워드'; ■ 값 자동 증가PgsqlCREATE SEQUENCE tablename_colname_seq; CREATE TABLE tablename ( colname integer DEFAULT nextval('tablename_colname_seq') NOT NULL );[출처] DBMS 별 자동증가값 처리방법|작성자 빛나리 2012. 12. 4. 이전 1 다음