Archive

Archive for January, 2012

[PostgreSQL] 연번 필드 생성

January 13, 2012 Leave a comment

0000 – 0100 문자열 생성

with recursive foo
AS
(
SELECT 0 seq
UNION ALL
SELECT seq + 1 FROM foo
WHERE seq + 1 <= 100
)
select lpad(cast (seq as varchar(8)), 4, ‘0’) from foo;

Vim 주요 사용법

January 7, 2012 Leave a comment

visual mode
v
Ctrl+v (컬럼 단위). ※ gvim 에서는 Ctrl+q 이며, 일괄 insert, append 시 대문자 “I”, “A” 사용.

SELinux

January 7, 2012 Leave a comment

기능끄기

# vi /etc/sysconfig/selinux
SELINUX=enforcing –>  SELINUX=disabled
# reboot

wget

January 6, 2012 Leave a comment

wget -x -nH –cut-dirs=1 -N -c -i url.txt