linux
a few seconds read (About 102 words)

postgres 基本操作及pgcrypto的使用

基本操作

mysql postgres
show database; \l
use database_name; \c database_name;
show tables; \d

pgcrypto的使用

详细资料请看这里, 常用操如下

加密方式 案例
digest
hmac
crypt
gen_salt 
1
2
3
4
5
6
7
8
9
10
11
12
13
// 
CREATE TABLE Staff (
   id    CHAR(4)    NOT NULL,
   name   TEXT       NOT NULL,
   age    INTEGER    ,
   PRIMARY KEY (id)
);

insert into staff (id, name, age) values(2, digest('name','md5'), 1);

insert into staff (id, name, age) values(3, digest('name','sha1'), 1);

insert into staff (id, name, age) values(4, hmac('name','a', 'md5'), 1);
#

Like this article? Support the author with

aws rds aurora postgresql extension pgcrypto
go gin

Comments

Categories

Tag Cloud

DASH FFMpeg WebGl WebRTC angular antd docker echartsjs ffmpeg flex git go google immutable keep update koa mac mongodb next.js nginx node nodejs npm nuxt.js nuxtjs pm2 postgres postgresql rabbitmq react redux regexp typescript vim vue vuejs 日语 水彩

Recent

Archives

Tags

DASH 1
FFMpeg 1
WebGl 9
WebRTC 4
angular 3
antd 1
docker 3
echartsjs 3
ffmpeg 1
flex 1
git 7
go 1
google 1
immutable 1
keep update 1
koa 1
mac 1
mongodb 1
next.js 1
nginx 2
node 5
nodejs 3
npm 3
nuxt.js 1
nuxtjs 1
pm2 1
postgres 1
postgresql 1
rabbitmq 1
react 6
redux 1
regexp 2
typescript 8
vim 3
vue 13
vuejs 1
日语 1
水彩 7

Recent

Archives

Tags

DASH 1
FFMpeg 1
WebGl 9
WebRTC 4
angular 3
antd 1
docker 3
echartsjs 3
ffmpeg 1
flex 1
git 7
go 1
google 1
immutable 1
keep update 1
koa 1
mac 1
mongodb 1
next.js 1
nginx 2
node 5
nodejs 3
npm 3
nuxt.js 1
nuxtjs 1
pm2 1
postgres 1
postgresql 1
rabbitmq 1
react 6
redux 1
regexp 2
typescript 8
vim 3
vue 13
vuejs 1
日语 1
水彩 7
Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×