# spring-boot-opengauss-demo

**Repository Path**: codorld/spring-boot-opengauss-demo

## Basic Information

- **Project Name**: spring-boot-opengauss-demo
- **Description**: springboot整合opengauss(目前与pgsql一模一样)简单应用
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2023-10-09
- **Last Updated**: 2024-02-21

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

- 全用pgsql的配置即可, 这个demo中都是兼容的. *openGauss中会有一个默认以登录名为名的模式(类似个人目录), 优先在自己的模式中找, 如果没有就去public中找*
- 创建测试表sql, user_test
    ```sql
    -- ----------------------------
    -- Table structure for user_test
    -- ----------------------------
    DROP TABLE IF EXISTS "public"."user_test";
    CREATE TABLE "public"."user_test" (
      "id" int4 NOT NULL,
      "num" varchar(100) COLLATE "pg_catalog"."default",
      "name" varchar(255) COLLATE "pg_catalog"."default",
      "note" varchar(255) COLLATE "pg_catalog"."default",
      "create_time" timestamp(6),
      "update_time" timestamp(6),
      "delete_time" timestamp(6)
    )
    ;
    
    -- ----------------------------
    -- Primary Key structure for table user_test
    -- ----------------------------
    ALTER TABLE "public"."user_test" ADD CONSTRAINT "user_test_pkey" PRIMARY KEY ("id");
    ```