posgresql jdbc

gistfile1.java

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Driver;
import java.sql.DriverManager;
import java.util.Properties;
 
public class Main {
 
	public static void main(String[] args) throws Throwable {
		
		Driver driver = (Driver)Class.forName("org.postgresql.Driver").newInstance();
		Properties prop = new Properties();
		prop.setProperty("protocolVersion", "2");
		prop.setProperty("user", "postgres");
		Connection conn = driver.connect("jdbc:postgresql://localhost:9990/hive", prop);
		conn.setAutoCommit(false);
		
		DatabaseMetaData metaData = conn.getMetaData();
		int maxColumnNameLength = metaData.getMaxColumnNameLength();
		System.out.println(maxColumnNameLength);
 
	}
 
}