PostgreSQL �̊‹��ϐ� PGPASSWORD

PostgreSQL ���g���Ă��ĔF�؂� md5 �ȂǂɂȂ��Ă���ꍇ psql �Őڑ����邽�тɃp�X���[�h�𕷂��Ă��܂��B

���ꂪ�ʓ|�ȏꍇ�� �‹��ϐ� PGPASSWORD �Ƀp�X���[�h��ݒ肵�Ă������Ƃ��ł��܂��B

$ echo "select * from pg_tables" | psql sample_db
Password:

�ʏ�́��̂悤�ɂȂ�܂��B

$ export PGPASSWORD=xxxxxx
$ echo "select * from pg_tables" | psql sample_db

�p�X���[�h�𕷂��Ă��Ȃ��Ȃ�܂��B
�i xxxxxx �́A�p�X���[�h�ł��j

�o�b�`�����Ȃǂł����̕��@���g���܂��B

Google �T�C�g������

Amazon�A�\�V�G�C�g