TFv5DEGS

1CREATE DATABASE "Inventarios"
2WITH OWNER = postgres
3ENCODING = 'UTF8'
4TABLESPACE = pg_default
5LC_COLLATE = 'Spanish_Mexico.1252'
6LC_CTYPE = 'Spanish_Mexico.1252'
7CONNECTION LIMIT = -1;
8	
9PreparedStatement ps = connection.prepareStatement("CREATE TABLE IF NOT EXISTS user(user_id SERIAL NOT NULL PRIMARY KEY,username varchar(225) NOT NULL UNIQUE,password varchar(225),islogged varchar(10))");
10ps.executeUpdate();
11ps.close();
12	
13CREATE DATABASE testdb;
14	
15try {
16        cnx = (Connection) DriverManager.getConnection(drive,user,paswd);
17        ps = cnx.prepareStatement("CREATE DATABASE "+bd);
18        ps.executeUpdate();
19        ps.close();
20    } catch (SQLException ex) {
21        System.out.println(ex);
22    }