PostgreSQL3 postgresql jdbc test code import java.sql.DriverManager;import java.sql.Connection;import java.sql.SQLException; public class Example1 { public static void main(String[] argv) { System.out.println("Checking if Driver is registered with DriverManager."); try { Class.forName("org.postgresql.Driver"); } catch (ClassNotFoundException cnfe) { System.out.println("Couldn't find the driver!"); System.out.println("Let's print a s.. 2016. 7. 25. create super user with password on postgresql postgres@ubuntu:~$ createuser -P -s -e test 새 롤의 암호:암호 확인:CREATE ROLE test PASSWORD 'md5f3084041c7669071a1dc54c05d3658cd' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN; 2016. 7. 25. create database in postgresql #DB 생성create database testDB with encoding 'unicode' LC_COLLATE 'C' LC_CTYPE 'C' template template0; #DB Owner 변경alter database testDB owner to testUser; 2016. 6. 27. 이전 1 다음