Poor - Because you have no ambition

PostgreSQL提供了一个隐藏参数zero_damaged_pages， 当这个参数为true的时候，会忽略所有数据有损坏的页面。database$> SET zero_damaged_pages = on;database$> VACUUM FULL damaged_table;database$> REINDEX TABLE damaged_table;...

PGsql循环删除库中表CREATE OR REPLACE FUNCTION public.del_table() RETURNS void LANGUAGE plpgsqlAS $function$DECLARE tmp VARCHAR(512);DECLARE names CURSOR FOR select tablename from pg_tables where schemaname='public';BEGIN FOR stmt IN names LOOP

An overview of SQL Server data types and their PostgreSQL equivalentsSQLServer 与 PostgreSQL 字段对应关系MSSQLPGSQLcharchar / textncharchar / textvarcharvarchar / textnvarcharvarchar / textxmltextintintegerbigintbigintb

Python连接PostgreSQL简单操作依赖：psycopg2# !/usr/bin/env python3# _*_ encoding: utf-8 _*_# Time ：2021-02-25 10:12# ++++++++++++++++++++++++++++++++++++++++++++++++++# 调用.sql文件 执行# 使用方法 python3 handleDB.py # param：文件名称# +++++++++++++++++++++++++++++++

select b.schemaname , c.relname as 表名, cast(obj_description(c.relfilenode, 'pg_class') as varchar) 表中文名, a.attnum as 序号, a.attname as 字段名, col_description ( a.attrelid, a.attnum ) as 字段描述, t.typname as type, a.attlen as

PostgreSQL 锁表1. 拼接解锁语句select 'select pg_cancel_backend(' || pid || ');'from ( select a.oid, b.pid, a.relname from pg_class a left join pg_locks b on a.oid = b.relation where a.relname like '%表名%')where pid is not null;2. 执行上句查询语句-

create user 用户名 superuser password ‘密码’;添加用户\c tablename切换数据库\l列举数据库，相当于mysql的 show database\dt列举表，相当于 mysql 的show tables\d tablename查看表结构，相当于 mysql的desc tablename\di查看索引\q推出create datab...

拉取镜像docker Pulling library/postgres运行Postgres(映射一个端口)：docker run --name postgres1 -e POSTGRES_PASSWORD=password -d -p 5432:5432 postgres将容器的端口5432映射到服务器端口5432。 -p< host_port>：< cont...