PG: psql
psql -h ip -p port -U username -d dbname作者: 郑全 时间: 2023-12-20 22:11
14.查看参数
oracle: show parameter para_name --模糊匹配,输入一部分
select name,value from v$parameter where name like '%para_name%'; --模糊匹配,输入一部分
pg: select name,setting from pg_settings where name like '%para_name%'; 模糊匹配,输入一部分
show max_wal_size; --参数要输全作者: 郑全 时间: 2023-12-29 11:03
15.行位置
ORACLE: ROWID
PG: 使用中,可以含DDL命令。如下:
postgres@:5432/postgres-2414#=begin;
BEGIN
postgres@:5432/postgres-2414#=create table xx(id numeric);
CREATE TABLE
postgres@:5432/postgres-2414#=insert into xx values(10);
INSERT 0 1
postgres@:5432/postgres-2414#=\d
List of relations
Schema | Name | Type | Owner
--------+-------------------------+-------+----------
public | log_student | table | postgres
public | pg_buffercache | view | postgres
public | pg_stat_statements | view | postgres
public | pg_stat_statements_info | view | postgres
public | score | table | postgres
public | student | table | postgres
public | t | table | postgres
public | test | table | postgres
public | xx | table | postgres
(9 rows)
postgres@:5432/postgres-2414#=rollback;
ROLLBACK
postgres@:5432/postgres-2414#=\d
List of relations
Schema | Name | Type | Owner
--------+-------------------------+-------+----------
public | log_student | table | postgres
public | pg_buffercache | view | postgres
public | pg_stat_statements | view | postgres
public | pg_stat_statements_info | view | postgres
public | score | table | postgres
public | student | table | postgres
public | t | table | postgres
public | test | table | postgres
(8 rows) 作者: 郑全 时间: 2023-12-29 18:08
18.表不存在,是否可以创建过程
PG : 可以创建多个不同的索引,而且多个可以有用
postgres@:5432/postgres-95655#=create index idx_test on test(id);
CREATE INDEX
postgres@:5432/postgres-95655#=create index idx_test1 on test(id);
CREATE INDEX
postgres@:5432/postgres-95655#=create index idx_test2 on test(id);
CREATE INDEX
postgres@:5432/postgres-95655#=\d test
Table "public.test"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
id | integer | | |
v | integer | | |
Indexes:
"idx_test" btree (id)
"idx_test1" btree (id)
"idx_test2" btree (id)