# fmartecpg

**Repository Path**: unmasks/fmartecpg

## Basic Information

- **Project Name**: fmartecpg
- **Description**: No description available
- **Primary Language**: C
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-10-02
- **Last Updated**: 2021-10-02

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 1.配置vscode的c开发环境
https://www.zhihu.com/question/333233461/answer/758817084  

# 2.下载PostgreSql
https://get.enterprisedb.com/postgresql/postgresql-14.0-1-windows-x64-binaries.zip   

将上面的zip文件下载并解压到（配置文件中用到此路径）：
```
D:\openSoft\pgsql-v14.0.1
```
同时新建空文件夹，初期化db用：
```
D:\openSoft\pgsql-v14.0.1-dbsvc
```
# 3.修改环境变数
```
PGHOME=D:\openSoft\pgsql-v14.0.1
PGDATA=D:\openSoft\pgsql-v14.0.1-dbsvc
Path中增加：D:\openSoft\pgsql-v14.0.1\bin
```

# 4.初期化db，启动Service，创建db，创建user
+ **初期化db**  
    > cmd下执行，成功后会在D:\openSoft\pgsql-v14.0.1-dbsvc中创建大量文件：
    > ```sql
    > initdb -E utf8 -D "D:\openSoft\pgsql-v14.0.1-dbsvc"
    > ```
+ **启动Service**  
    > cmd下执行：
    > ```sql
    > pg_ctl start -D "D:\openSoft\pgsql-v14.0.1-dbsvc" -l pgsql.log
    > ```
+ **创建db**  
    > cmd下执行：
    > ```sql
    > createdb db01
    > ```
+ **创建user**  
    > cmd下执行(-P会提示输入密码)：
    > ```sql
    > createuser user01 -P
    > ```

# 5.给用户授权
cmd下执行：
```sql
psql -d db01
```
进入psql环境：
```sql
-- 将db01权限授权于user01
db01=$ grant all privileges on database db01 to user01;
-- 将当前db01下 public schema 的表都授权于user01
db01=$ grant all privileges on all tables in schema public to user01;
```


# 6.利用新用户连接数据库
```
psql -U user01 -W -d db01
```

# 7.创建数据表
```sql
CREATE TABLE employees (
    EMPLOYEE_ID int NOT NULL,
    FIRST_NAME TEXT,
    LAST_NAME TEXT NOT NULL,
    EMAIL TEXT NOT NULL,
    PHONE_NUMBER TEXT,
    HIRE_DATE DATE NOT NULL,
    JOB_ID TEXT NOT NULL,
    SALARY float,
    COMMISSION_PCT float,
    MANAGER_ID int,
    DEPARTMENT_ID int,
    PRIMARY KEY(EMPLOYEE_ID)
);

INSERT INTO employees VALUES(100,'Steven','King','SKING','123','2021/09/02','SALESXX',24000,NULL,NULL,90);
INSERT INTO employees VALUES(101,'Neena','Kochhar','NKOCHHAR','234','2021/09/02','SALESYY',17000,NULL,100,90);
```
# 8.选择/新建一个pgc文件，然后F5键执行。