명령 샘플

1. 파일로 EXPORT

COPY poidb TO 'E:\db.csv' DELIMITER ',' CSV HEADER ENCODING 'euc-kr';

2. 테이블 존재 확인

SELECT EXISTS (SELECT 'OK' FROM  information_schema.tables  WHERE table_schema = 'public' AND table_name = 'ncode');

3. 필드 존재 확인

SELECT EXISTS (SELECT "OK" FROM information_schema.columns WHERE table_name='poidb' and column_name='name_full');