2024年4月23日发(作者：)

java 获取pg数据库建表语句

下面是使用Java获取PG数据库建表语句的示例，共计10个示例。

示例1：创建用户表

```java

String createTableSQL = "CREATE TABLE users ("

+ "id SERIAL PRIMARY KEY,"

+ "username VARCHAR(50) NOT NULL,"

+ "password VARCHAR(50) NOT NULL,"

+ "email VARCHAR(100) NOT NULL,"

+ "created_at TIMESTAMP DEFAULT

CURRENT_TIMESTAMP);";

```

该示例演示了创建一个名为"users"的表，包含id、username、

password、email和created_at五个字段，其中id为自增主键，

其他字段都不能为空。

示例2：创建商品表

```java

String createTableSQL = "CREATE TABLE products ("

+ "id SERIAL PRIMARY KEY,"

+ "name VARCHAR(100) NOT NULL,"

+ "price DECIMAL(10,2) NOT NULL,"

+ "description TEXT,"

+ "created_at TIMESTAMP DEFAULT

CURRENT_TIMESTAMP);";

```

该示例创建了一个名为"products"的表，包含id、name、price、

description和created_at五个字段，其中id为自增主键，name

和price字段不能为空，description字段为文本类型。

示例3：创建订单表

```java

String createTableSQL = "CREATE TABLE orders ("

+ "id SERIAL PRIMARY KEY,"

+ "user_id INTEGER NOT NULL,"

+ "product_id INTEGER NOT NULL,"

+ "quantity INTEGER NOT NULL,"

+ "total_price DECIMAL(10,2) NOT NULL,"

+ "created_at TIMESTAMP DEFAULT

CURRENT_TIMESTAMP,"

+ "FOREIGN KEY (user_id) REFERENCES users(id),"

+ "FOREIGN KEY (product_id) REFERENCES

products(id));";

```