Notice
Recent Posts
Recent Comments
Tags
- openldap
- 우파푸른하늘
- 웰카
- vmware
- 우파푸른하늘80만이벤트
- maxscale
- Kubernetes
- n15148
- etcd
- Auth
- admin port
- RHEL8
- drbd
- wildfly jboss
- unix_socket
- web&was apche htaccess
- Storage
- mgmtip
- dell
- CentOS
- Path
- docker
- snmp
- mariadb
- data-door
- perplexity
- CEP
- Network
- MotD
- n1548
- port description
- Galera Cluster
- banner
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