?? pgbash?̊T?v
- ?f?[?^?x?[?X?E?C???^?[?t?F?C?X
pgbash?́Abash?V?F???̒??? PostgreSQL?p?̒???SQL/????SQL?C???^?[?t?F?C?X??g?ݍ???ł??܂??B
?????ŁA?u????SQL?v?Ƃ́ASQL????͂???Ƒ????Ɏ??s???Ă??̌??ʂ?W???o?͂ɏo?͂???@?\??\???܂??B?܂??A?u????SQL?v?Ƃ́A???????ʂ??V?F???ϐ??ɑ?????A?V?F???X?N???v?g????ŏ???????@?\??\???܂??BPgbash?ł́ASELECT_INTO?? ???????́@FTECH_INTO?????u????SQL?v?Ƃ??Ďg?p???�?Ƃ??ł??܂??B
- ?��b?^??SQL?????s
Pgbash???A???O?C???V?F?????????̓T?u?V?F???i?e?̃V?F??????N?????ꂽ?q?̃V?F???j?Ƃ??ċN?????A?R?}???h???C????SQL??????͂??đ????Ɏ??s???�?Ƃ??ł??܂??B?܂??ASQL???ƃp?C?v???C???^???_?C???N?V?????A?o?b?N?O?????h?W???u???߂Ȃǂ?g?ݍ???Ď??s???�?Ƃ??ł??܂??B
- ?V?F???X?N???v?g???쐬?”\
Pgbash?́Abash?V?F?????????Ă???V?F???X?N???v?g?@?\???g?p???āA?V?F???X?N???v?g???쐬???�?Ƃ??ł??܂??Bbash?V?F????IF/WHILE?Ȃǂ̐??䕶?ASQL???▄??SQL?????g?p???ăV?F???X?N???v?g???쐬???܂??B
- Web?A?v???P?[?V???????쐬?”\
Pgbash?́AWeb?A?v???P?[?V????(CGI ?v???O????)?Ƃ??Ďg?p???邽?߂ɁAGET/POST???\?b?h?̃f?[?^???V?F???ϐ??Ɏ????I?ɃZ?b?g????@?\??????Ă??܂??B
- ???s?‹?
Pgbash?́AUnix?‹????????? Windows??Cygwin?‹??Ŏ??s?”\?ł??BPgbash?́Apsql ?Ƃقړ????̋@?\????????s?‹??? psql?Ɠ??l?ɂȂ?܂??B
- ?��b?^?‹??ݒ?t?@?C??
Pgbash?̑��b?^?‹??ł́Abash?V?F???Ɠ??l?? .bash_profile(???O?C???V?F???p)?A.bashrc(?T?u?V?F???p)?‹??ݒ?t?@?C???Ȃǂ??K?v?ɂȂ?܂??B
?܂??A?f?[?^?x?[?X?‹??ݒ?t?@?C???Ƃ??? pgbashrc ???K?v?ł??Bpgbashrc?́A?��b?‹??ő??삷???ŕ֗??ȃR?}???h??A?f?[?^?x?[?X????\?????邽?߂̊e??R?}???h???ݒ肳??Ă??܂??B
pgbashrc ?́A?܂? ~/.pgbashrc ??ǂ݁A???݂??Ă??Ȃ???? /etc/pgbashrc ??ǂ݂܂??BPgbash???N?????́Asource ?R?}???h?ɂ???čēǂݍ??݂??�?Ƃ??ł??܂??B
?? pgbash?̓???
- ?��b?^?‹??ɂ?????@?\
- pgbash?́Apsql ?Ɠ????̃f?[?^?x?[?X?A?N?Z?X?@?\???L??܂??B
- pgbash?́Apgbashrc ???g?p???ă??[?U?Ǝ??̑��b?^?‹????ȒP?ɐݒ?ł??܂??B
- pgbash?́Abash?̕W???@?\?ł??? alias?Afunction?A???엚???̗??p?Ȃǂ??_??ȑ��b?^?̑???‹?????�?Ƃ??ł??܂??B
- pgbash?́ASQL???p?C?v???C???A???_?C???N?V?????A?o?b?N?O?????h?W???u?Ƃ?g?ݍ??킹?Ď??s???�?Ƃ??ł??܂??B
- pgbash?Ǝ???SQL?g???@?\
- pgbash?́ACONNECT, DISCONNECT, SET CONNECTION??p???āA?????̃f?[?^?x?[?X?ɃA?N?Z?X???�?Ƃ??ł??܂??B
- pgbash?́A?uSELECT INTO ?F?z?X?g?ϐ??v????uFETCH INTO ?F?z?X?g?ϐ??v???ɂ???????????ʂ??V?F???ϐ??ɑ??????@?\??????܂??B
- pgbash?́ASQL???s??̃G???[?R?[?h?ASELECT?̌??ʂ̃^?v?????A?A?Ȃǂ??V?F???ϐ??ɕۊǂ??܂??B
- Web?A?v???P?[?V?????Ƃ??Ă̋@?\
- pgbash?́ASQL?o?͂?HTML?ɐ?ւ??AGET/POST???\?b?h?ɂ??f?[?^?̓Ǎ??AHTTP_COOKIE ?̒l?̓Ǎ??Ȃǂ??????I?ɍs???@?\??????܂??B
- pgbash?́ASELECT?̌??ʂ??????I??HTML??TABLE?`???ŏo?͂ł??܂??B???̍ۂɁATABLE ?^?O?A?w?b?_?[???? TR?^?O?ATH?^?O?A?{?f?B???? TD?^?O??ύX???�?Ƃ??ł??܂??B
?? ?J??????
- 1999.07.?? : pgsql-jp ???[?????O???X?g(ML)?ɂăC???^?[?t?F?C?X?̌????B
- 1999.07.?? : ?v?ی??m???? pqbash???쐬???? pgsql-jp ML?Ō??J?B
- 1999.07.?? : ????SQL/????SQL??pgbash?? pgsql-jp ML?Ō????B
- 1999.08.31 : pgbash-1.0-beta ?????J?B
- 1999.09.30 : pgbash-1.1.0?????J(CGI?@?\?̒lj??A?o?͌`???̓???j
- 1999.10.30 : pgbash-1.2.1?????J(????‹??̐?????COPY???̋@?\?lj??j
- 1999.11.22 : pgbash-1.2.3?????J(SQLOID?V?F???ϐ??̒lj?)
- 1999.12.25 : pgbash-2.0?????J (bash-2.03?{?̂??C??????SQL???s?@?\??lj?)
- 2000.01.07 : pgbash-2.0.1?????J(MB???????N?A?V?X?e?????b?Z?[?W?o?͐???lj?)
- 2000.05.16 : pgbash-2.1(bash-2.03) ?????J(PostgreSQL-6.5/7.0?ɑΉ?)
- 2001.05.01 : pgbash-2.2(bash-2.03/2.04/2.05)?????J(PostgreSQL-6.5/7.0/7.1?ɑΉ?)
- 2001.12.15 : pgbash-2.4(PostgreSQL-7.0/7.1/7.2?ɑΉ?)?????J
- 2002.02.10 : pgbash-2.4a(bash-2.05a?ɑΉ?)?????J
- 2002.05.10 : pgbash-2.4a.1?????J
- 2002.07.22 : pgbash-2.4a.2?????J
- 2003.02.10 : pgbash-7.3?????J
- 2003.10.14 : pgbash-7.3a(pgbash-7.3 bug fix) by Tomo Nomura.
- 2011.08.15 : pgbash-8r2.05 ?????J
- 2011.08.20 : pgbash-8r3.2 ?????J
- 2011.08.25 : pgbash-8r4.1 ?????J
?? ??ȍX?V???e(2011?N8??)
- PostrgeSQL 7.4,8.0, 8.1, 8.2, 8.3, 8.4, 9.0 ?ɑΉ?
- bash 2.05a, bash-3.2.48, bash-4.1.10 ?ɑΉ?
- pgbash?Ǝ???COPY?@?\???폜
- Web?A?v???P?[?V?????쐬???? EXEC_SQL_PREPARE?@?\???폜
?? ?֘A?y?[?W
|
Last Modified at 2011/08/25