하루에 한가지

-- 컬럼 정보 조회.. with info as ( select '%%' table_catalog ,'%%' table_schema ,'%' table_name from dual ) ,t_cmmt as ( SELECT ps.schemaname as table_schema ,PS.RELNAME as table_name ,PD.DESCRIPTION AS TABLE_COMMENT FROM PG_STAT_USER_TABLES PS inner join PG_DESCRIPTION PD on PS.RELID = PD.OBJOID WHERE 1=1 and ps.schemaname = (select table_schema from info) and PS.RELNAME like '%'||(select table_name ..

DB 생성 db의 인코딩에 주위해야 한다. db connection 부터 인코딩을 탄다. public class Ping { public static void main(String[] args) throws ClassNotFoundException, SQLException { //String url = "jdbc:postgresql:postgres"; String url = "jdbc:postgresql://localhost:5432/Test"; String usr = "postgres"; String pwd = "1111"; Class.forName("org.postgresql.Driver"); Connection db = DriverManager.getConnection(url, usr, pwd); ..