数据库【postgres】

.netcore版本连接串 PostgreSql

  "ConnPg": {
    "remark": "xxx",
    "providerName": "Npgsql",
    "name": "ConnPg",
    "read": [ "Host=xxxx;Port=5432;Database=postgres;Username=postgres;Password=xxxxx;"
    ],
    "write": [ "Host=xxxx;Port=5432;Database=postgres;Username=postgres;Password=xxxxx;"
    ]
  },

.netcore 操作

https://www.ssfiction.com/ckf/997758.html

https://www.ssfiction.com/ckf/1002594.html

string test; using (NpgsqlCommand cmd = new NpgsqlCommand("insert into foo values (:TEST)", conn)) { cmd.Parameters.AddWithValue("TEST", NpgsqlTypes.NpgsqlDbType.Varchar, (object)test?? DBNull.Value); cmd.ExecuteNonQuery();

文档

http://www.yiidian.com/postgresql/postgresql-intro.html

常用操作手册

https://www.runoob.com/postgresql/postgresql-functions.html

https://blog.csdn.net/zhangbeizhen18/article/details/128266173

PostgreSQL帮助手册：

官网入口：https://www.postgresql.org/

文档入口：https://www.postgresql.org/docs

文档内容列表：https://www.postgresql.org/docs/current/

支持的命令列表：https://www.postgresql.org/docs/current/reference.html

psql命令行列表：https://www.postgresql.org/docs/current/app-psql.html

1.PostgreSQL数据库

1.1PostgreSQL

PostgreSQL: The World’s Most Advanced Open Source Relational Database.

PostgreSQL is a powerful, open source object-relational database system that has earned it a strong reputation for reliability, feature robustness, and performance.

解析：PostgreSQL是一个先进的开源关系型数据库。在可靠性、健壮性和性能方面赢得很高声誉。

1.2PostgreSQL历史版本下载

(1)下载地址

官网地址：https://ftp.postgresql.org/pub/source/

当前运行的语句和锁

https://blog.csdn.net/yueludanfeng/article/details/83340034