SELECT
*
FROM
PG_CATALOG.PG_LOCKS l, PG_CATALOG.PG_STAT_ALL_TABLES t
WHERE
l.RELATION = t.RELID
ORDER BY l.RELATION ASC
;
SELECT
*
FROM PG_CATALOG.PG_STAT_ACTIVITY
WHERE
DATNAME = 'postgre_db' --'DB명'
AND WAIT_EVENT_TYPE = 'Lock'
ORDER BY QUERY_START DESC
;
SELECT a.osuser
,a.SID
,a.serial#
,a.status
,a.CLIENT_ADDR
,b.QUERY
FROM PG_CATALOG.PG_STAT_ACTIVITY a
,PUBLIC.PG_STAT_STATEMENTS b
WHERE a.USESYSID = b.USERID
;
select * from PG_CATALOG.PG_STAT_ACTIVITY ;
select * from PUBLIC.PG_STAT_STATEMENTS ;
SELECT * FROM PG_CATALOG.PG_NAMESPACE PN
;
SELECT * FROM PG_CATALOG.PG_TABLES PT
;
SELECT
*
FROM
PG_CATALOG.PG_TABLES PT
WHERE
PT.SCHEMANAME = 'schemaname'
AND TABLENAME LIKE '%tablename%'
;
alter table "테이블명" rename to "변경후테이블명";
alter table 테이블명 rename column "as-is컬럼명" to "to-be컬럼명";
ALTER table 테이블명 ALTER COLUMN 컬럼명 TYPE NUMERIC USING 컬럼명::NUMERIC;
mysql처럼 join~on 구문 혹은 oracle 에서 처럼 from절에 테이블 여러개 놓고, where 절에서 조건 작성 둘 다 가능.