반응형 Dev/Postgresql7 Postgresql DO END Sample DO $$ DECLARE p_idx integer := 252; BEGIN delete from t_history where idx = p_idx; END $$; 2022. 11. 11. CMD에서 psql SQL import cmd set PGPASSWORD=pwd&& "D:/00.ProgramFile/PostgreSQL/11/bin/psql.exe" -p 5434 -U malluser -c "SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid pg_backend_pid() AND datname = 'db_name';"; set PGPASSWORD=pwd&& "D:/00.ProgramFile/PostgreSQL/11/bin/psql.exe" -p 5434 -U malluser -c "drop database db_name;"; set PGPASSWORD=pwd&& "D:/00.ProgramFile/PostgreSQL/11/bin/psql.exe" .. 2022. 4. 24. [PostgreSQL] 이번달의 첫번째 날과 마지막날 구하기 이번달 첫번째 날(01일) , 마지막날(30,31일) 구하기. SELECT cast(date_trunc('month',current_date) as date) as firstday, (date_trunc('MONTH', current_date) + INTERVAL '1 MONTH - 1 day')::date lastday; 2022. 3. 30. Postgresql Procedure Sample PG/SQL Procedure Sample CREATE TABLE USERS ( USER_ID BPCHAR(20) NOT NULL, USER_NAME BPCHAR(30) NULL, USER_AGE INT4 NULL ); CREATE OR REPLACE PROCEDURE SAMPLE_CURSOR() LANGUAGE PLPGSQL AS $PROCEDURE$ DECLARE TARGET_CURSOR RECORD; BEGIN FOR TARGET_CURSOR IN SELECT USER_ID, USER_AGE FROM USERS LOOP UPDATE USERS SET USER_AGE = USER_AGE+1 WHERE USER_ID = TARGET_CURSOR.USER_ID; END LOOP; END; $PROCEDU.. 2022. 3. 29. 이전 1 2 다음 반응형