Notice
Recent Posts
Recent Comments
Tags
- 우파푸른하늘
- snmp
- port description
- Galera Cluster
- Auth
- mgmtip
- banner
- wildfly jboss
- 우파푸른하늘80만이벤트
- drbd
- vmware
- CentOS
- openldap
- Path
- data-door
- Storage
- web&was apche htaccess
- mariadb
- CEP
- MotD
- perplexity
- n15148
- etcd
- RHEL8
- Kubernetes
- unix_socket
- n1548
- maxscale
- admin port
- Network
- 웰카
- docker
- dell
250x250
반응형
전산쟁이의 기억노트
postgresql 트랜젝션 테스트 본문
728x90
반응형
testdb=> select * from member;
num | name
-----+-----------
1 | test
2 | test123
3 | test12
4 | test12
5 | test12
6 | test12123
(6 rows)
testdb=> begin;
BEGIN
testdb=> insert into member values (7,'test12123');
INSERT 0 1
testdb=> insert into member values (8,'test12123');
INSERT 0 1
testdb=> select * from member;
num | name
-----+-----------
1 | test
2 | test123
3 | test12
4 | test12
5 | test12
6 | test12123
7 | test12123
8 | test12123
(8 rows)
testdb=> rollback;
ROLLBACK
testdb=> select * from member;
num | name
-----+-----------
1 | test
2 | test123
3 | test12
4 | test12
5 | test12
6 | test12123
(6 rows)
728x90
반응형
'postgresql' 카테고리의 다른 글
postgresql 데이터 백업/관리 (0) | 2022.10.24 |
---|---|
postgres 로그디렉토리 생성하기 (0) | 2022.10.21 |
postgres 기초쿼리 정보들 (0) | 2022.10.21 |
postgresSQL 9.4.26 설치 (1) | 2022.08.04 |
postgresSQL 9.2.4 설치 (0) | 2022.08.04 |
Comments