조이리

보통 MSSQL이나 MySQL을 쓰신분들은 isNull이나 ifNull에 익숙하시지만 포스트그레스큐엘에선 coalesce 를 사용합니다. select coalesce(인자1, 인자2) from table 결과가 null이아니면 인자1값을 가져오고 null이면 인자2를 반환

오류 FATAL: Peer authentication failed for user "postgres" The problem is still your pg_hba.conf file (/etc/postgresql/9.1/main/pg_hba.conf). This line: local all postgres peer 를 local all postgres md5 이렇게 변경 trust - anyone who can connect to the server is authorized to access the databasepeer - use client's operating system user name as database user name to access it.md5 - password-base authenti..