[PostgreSQL] select, insert, update, delete

1. SELECT

SELECT account_id, account_pw, nickname, region, birthday, gender, input_date, input_id, update_date, update_id
FROM public.account_info;

 

2. INSERT

INSERT INTO public.account_info
(account_id, account_pw, nickname, region, birthday, gender, input_date, input_id, update_date, update_id)
VALUES('', '', '', '', '', '', '', '', '', '');

 

3.UPDATE

UPDATE public.account_info
SET account_id='', account_pw='', nickname='', region='', birthday='', gender='', input_date='', input_id='', update_date='', update_id='';

 

4.DELETE

DELETE FROM public.account_info
WHERE tableoid=0 AND cmax=? AND xmax=? AND cmin=? AND xmin=? AND ctid=? AND account_id='' AND account_pw='' AND nickname='' AND region='' AND birthday='' AND gender='' AND input_date='' AND input_id='' AND update_date='' AND update_id='';