Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.1) with ESMTP id OAA03167 for ; Thu, 29 Apr 1999 14:06:54 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id OAA30657; Thu, 29 Apr 1999 14:04:41 -0400 Received: by localhost with Microsoft MAPI; Thu, 29 Apr 1999 14:07:33 -0400 Message-ID: <01BE9249.A06516C0.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'ic94006@solar6.ingenieria.uatx.mx'" Cc: "'pgsql-interfaces@hub.org'" Subject: perl / pg / cgi / postgres Date: Thu, 29 Apr 1999 14:07:32 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="---- =_NextPart_000_01BE9249.A06516C0" ------ =_NextPart_000_01BE9249.A06516C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit here are some examples that work with our test postgres database, all using perl's pg and cgi modules. they are not very pretty (formatting)! hope they help. jt *************************** Date: Wed, 28 Apr 1999 15:51:02 -0600 (CST) From: "Ilhuicatzi Cortes J. Henry" Subject: Pg and Perl!! Hi: im using Pg to make CGI's beetwen Postgres and perl, where can i find examples about Pg. I have tried to make any CGI's and doesn't work fine. Does someone have any examples about CGI? Atte. Henry Ilhuicatzi Cortes Universidad Autonoma de Tlaxcala Mexico. ------ =_NextPart_000_01BE9249.A06516C0 Content-Type: application/octet-stream; name="dataentry.cgi" Content-Transfer-Encoding: base64 IyEvdXNyL2Jpbi9wZXJsCnVzZSBDR0kgcXcoOnN0YW5kYXJkKTsKdXNlIFBnOwokY2dpX29iamVj dCA9IG5ldyBDR0k7CnByaW50ICRjZ2lfb2JqZWN0LT5oZWFkZXI7Cm15ICRiZ24gPSBwYXJhbSgi YmduIik7Cm15ICR1c2Vyc2VxID0gcGFyYW0oInVzZXJzZXEiKTsKbXkgJHVzZXJuYW1lID0gcGFy YW0oInVzZXJuYW1lIik7Cm15ICRzdGFydHRpbWUgPSBwYXJhbSgic3RhcnR0aW1lIik7Cm15ICRz dG9wdGltZSA9IHBhcmFtKCJzdG9wdGltZSIpOwpteSAkdXNlcnBob25lID0gcGFyYW0oInVzZXJw aG9uZSIpOwpteSAkY3VzdHJlZiA9IHBhcmFtKCJjdXN0cmVmIik7Cm15ICRtZmdyZWYgPSBwYXJh bSgibWZncmVmIik7Cm15ICRjb21wYW55ID0gcGFyYW0oImNvbXBhbnkiKTsKbXkgJGNvbnRhY3Qg PSBwYXJhbSgiY29udGFjdCIpOwpteSAkYWRkcjEgPSBwYXJhbSgiYWRkcjEiKTsKbXkgJGFkZHIy ID0gcGFyYW0oImFkZHIyIik7Cm15ICRjaXR5ID0gcGFyYW0oImNpdHkiKTsKbXkgJHN0YXRlID0g cGFyYW0oInN0YXRlIik7Cm15ICR6aXAgPSBwYXJhbSgiemlwIik7Cm15ICRwaG9uZSA9IHBhcmFt KCJwaG9uZSIpOwpteSAkZXF1aXAgPSBwYXJhbSgiZXF1aXAiKTsKbXkgJHNlcmlhbCA9IHBhcmFt KCJzZXJpYWwiKTsKbXkgJHN2Y25lZWRlZCA9IHBhcmFtKCJzdmNuZWVkZWQiKTsKbXkgJHRlY2hu b3RlcyA9IHBhcmFtKCJ0ZWNobm90ZXMiKTsKbXkgJHN2Y3BlcmYgPSBwYXJhbSgic3ZjcGVyZiIp OwpteSAkc3ZjZGF0ZSA9IHBhcmFtKCJzdmNkYXRlIik7Cm15ICRwYXJ0c2luID0gcGFyYW0oInBh cnRzaW4iKTsKbXkgJHRpbWVpbiA9IHBhcmFtKCJ0aW1laW4iKTsKbXkgJHRpbWVvdXQgPSBwYXJh bSgidGltZW91dCIpOwpteSAkcnRtaW5zID0gcGFyYW0oInJ0bWlucyIpOwpteSAkcnRtaWxlcyA9 IHBhcmFtKCJydG1pbGVzIik7Cm15ICRhYm91dCA9IHBhcmFtKCJhYm91dCIpOwpteSAkYWJydHJu ID0gcGFyYW0oImFicnRybiIpOwpteSAkZXRhZGF0ZSA9IHBhcmFtKCJldGFkYXRlIik7Cm15ICRh Y3Rjb2RlID0gcGFyYW0oImFjdGNvZGUiKTsKbXkgJHN0YXR1cyA9IHBhcmFtKCJzdGF0dXMiKTsK bXkgJHByb2IgPSBwYXJhbSgicHJvYiIpOwpteSAkY2F1c2UgPSBwYXJhbSgiY2F1c2UiKTsKbXkg JGFjdGlvbiA9IHBhcmFtKCJhY3Rpb24iKTsKbXkgJGNvbmYgPSBwYXJhbSgiY29uZiIpOwpteSAk ZGlzcG5vdGVzID0gcGFyYW0oImRpc3Bub3RlcyIpOwokY29ubiA9IFBnOjpjb25uZWN0ZGIoImhv c3Q9Zml4ZWQgcG9ydD01NDMyIGRibmFtZT10ZXN0IHVzZXI9aHVnZ2luc2QiKTsKcHJpbnQgc3Rh cnRfaHRtbCgiTVBTIERhdGEgRW50cnkgRXZhbHVhdGlvbiBGb3JtIiksIGgxKCJNUFMgRGF0YSBF bnRyeSBFdmFsdWF0aW9uIEZvcm0iKTsKaWYgKHBhcmFtKCkpIHsKCXByaW50ICI8dGFibGUgYm9y ZGVyPTIgdGV4dD0rMj4iOyAKCXByaW50ICI8dHI+XG4iOyAKCXByaW50ICI8dGQ+IiwgJHVzZXJz ZXEsICI8L3RkPiI7CglwcmludCAiPC90cj5cbiI7IHByaW50ICI8L3RhYmxlPlxuIjsKCSRxdWVy eSA9ICJ1cGRhdGUgZGF0YWVudHJ5IHNldCB1c2VybmFtZT0nJHVzZXJuYW1lJywgdXNlcnBob25l PSckdXNlcnBob25lJywgY3VzdHJlZj0nJGN1c3RyZWYnLCBtZmdyZWY9JyRtZmdyZWYnLCBjb21w YW55PSckY29tcGFueScsIGNvbnRhY3Q9JyRjb250YWN0JywgYWRkcjE9JyRhZGRyMScsIGFkZHIy PSckYWRkcjInLCBjaXR5PSckY2l0eScsIHN0YXRlPSckc3RhdGUnLCB6aXA9JyR6aXAnLCBwaG9u ZT0nJHBob25lJywgZXF1aXA9JyRlcXVpcCcsIHNlcmlhbD0nJHNlcmlhbCcsIHN2Y25lZWRlZD0n JHN2Y25lZWRlZCcsIHRlY2hub3Rlcz0nJHRlY2hub3RlcycsIHN2Y3BlcmY9JyRzdmNwZXJmJywg c3ZjZGF0ZT0nJHN2Y2RhdGUnLCBwYXJ0c2luPSckcGFydHNpbicsIHRpbWVpbj0nJHRpbWVpbics IHRpbWVvdXQ9JyR0aW1lb3V0JywgcnRtaW5zPSckcnRtaW5zJywgcnRtaWxlcz0nJHJ0bWlsZXMn LCBhYm91dD0nJGFib3V0JywgYWJydHJuPSckYWJydHJuJywgZXRhZGF0ZT0nJGV0YWRhdGUnLCBh Y3Rjb2RlPSckYWN0Y29kZScsIHN0YXR1cz0nJHN0YXR1cycsIHByb2I9JyRwcm9iJywgY2F1c2U9 JyRjYXVzZScsIGFjdGlvbj0nJGFjdGlvbicsIGNvbmY9JyRjb25mJywgZGlzcG5vdGVzPSckZGlz cG5vdGVzJywgc3RvcHRpbWU9J25vdycgd2hlcmUgdGV4dCh1c2Vyc2VxKT0nJHVzZXJzZXEnOyI7 CgkjJHF1ZXJ5ID0gInVwZGF0ZSBkYXRhZW50cnkgc2V0IHVzZXJuYW1lPSckdXNlcm5hbWUnLCB1 c2VycGhvbmU9JyR1c2VycGhvbmUnLCBzdG9wdGltZT0nbm93JyB3aGVyZSB0ZXh0KHVzZXJzZXEp PSckdXNlcnNlcSc7IjsKCSRyZXN1bHQ9JGNvbm4tPmV4ZWMoIiRxdWVyeSIpOyAKCSRxdWVyeT0i c2VsZWN0IHVzZXJzZXEsIHVzZXJuYW1lLCB1c2VycGhvbmUsIHN0YXJ0dGltZSwgc3RvcHRpbWUs IHN0b3B0aW1lLXN0YXJ0dGltZSBmcm9tIGRhdGFlbnRyeSB3aGVyZSB0ZXh0KHVzZXJzZXEpPSck dXNlcnNlcSc7IjsKCSRyZXN1bHQ9JGNvbm4tPmV4ZWMoIiRxdWVyeSIpOwoJcHJpbnQgIjx0YWJs ZSBib3JkZXI9MiB0ZXh0PSsyPiI7CglwcmludAoiPHRyPjx0aD51c2Vyc2VxPC90aD48dGg+dXNl cm5hbWU8L3RoPjx0aD51c2VycGhvbmU8L3RoPjx0aD5zdGFydHRpbWU8L3RoPjx0aD5zdG9wdGlt ZTwvdGg+PHRoPmZpbmlzaGVkIGluPC90aD48L3RyPlxuIjsKCXdoaWxlIChAcm93PSRyZXN1bHQt PmZldGNocm93KSB7CgoJCXByaW50ICI8VFI+XG4iOwoJCXByaW50ICI8VEQ+IiwgJHJvd1swXSwg IjwvVEQ+IjsKCQlwcmludCAiPFREPiIsICRyb3dbMV0sICI8L1REPiI7CgkJcHJpbnQgIjxURD4i LCAkcm93WzJdLCAiPC9URD4iOwoJCXByaW50ICI8VEQ+IiwgJHJvd1szXSwgIjwvVEQ+IjsKCQlw cmludCAiPFREPiIsICRyb3dbNF0sICI8L1REPiI7CgkJcHJpbnQgIjxURD4iLCAkcm93WzVdLCAi PC9URD4iOwoJCXByaW50ICI8VEQ+IiwgJHJvd1s2XSwgIjwvVEQ+IjsKCQlwcmludCAiPFREPiIs ICRyb3dbN10sICI8L1REPiI7CgkJcHJpbnQgIjxURD4iLCAkcm93WzhdLCAiPC9URD4iOwoJCXBy aW50ICI8VEQ+IiwgJHJvd1s5XSwgIjwvVEQ+IjsKCQlwcmludCAiPC9UUj5cbiI7Cgl9Cglwcmlu dCAiPC90YWJsZT5cbiI7Cn0gZWxzZSB7CgkkcXVlcnk9Imluc2VydCBpbnRvIGRhdGFlbnRyeSAo YmduLCBzdGFydHRpbWUpIHZhbHVlcyAoJ3knLCdub3cnKTsiOwoJJHJlc3VsdD0kY29ubi0+ZXhl YygiJHF1ZXJ5Iik7CgkkcXVlcnk9InNlbGVjdCBtYXgodXNlcnNlcSkgZnJvbSBkYXRhZW50cnk7 IjsKCSRyZXN1bHQ9JGNvbm4tPmV4ZWMoIiRxdWVyeSIpOwoJcHJpbnQgaHIsIHN0YXJ0X2Zvcm07 Cgl3aGlsZSAoQHJvdz0kcmVzdWx0LT5mZXRjaHJvdykgewoJJHVzZXJzZXE9JHJvd1swXTsKCXBy aW50ICI8dGFibGUgYm9yZGVyPTIgdGV4dD0rMj4iOwoJcHJpbnQgIjxUUj5cbiI7CglwcmludCAi PFREPiIsICRyb3dbMF0sICI8L1REPiI7CglwcmludCAiPFREPiIsICR1c2Vyc2VxLCAiPC9URD4i OwoJcHJpbnQgIjwvVFI+XG4iOwoJfQoJcHJpbnQgIjwvdGFibGU+XG4iOwoJI3ByaW50IHAoInVz ZXJzZXE6ICIsICR1c2Vyc2VxKTsKCXByaW50IHAoIlBMRUFTRSBSRUFEISEhICBETyBOT1QgVVNF IFRIRSBFTlRFUiBLRVkgVU5USUwgWU9VIEFSRSBET05FISAgVVNFIFRBQiBPUgpUSEUgTU9VU0Ug SU5TVEVBRCEgIERPIE5PVCBFTlRFUiBBTlkgU0lOR0xFIE9SIERPVUJMRSBRVU9URVMhIiwgaGlk ZGVuKCJ1c2Vyc2VxIiwkdXNlcnNlcSkpOwoJcHJpbnQgcCgiV2hhdCBpcyB5b3VyIG5hbWU6ICIs IHRleHRmaWVsZCgidXNlcm5hbWUiLCIiKSk7CglwcmludCBwKCJXaGF0IGlzIHlvdXIgcGhvbmUg bnVtYmVyOiAiLCB0ZXh0ZmllbGQoInVzZXJwaG9uZSIsIiIpKTsKCXByaW50IHAoIkN1c3RvbWVy IFJlZmVyZW5jZTogIiwgdGV4dGZpZWxkKCJjdXN0cmVmIiwiIikpOwoJcHJpbnQgcCgiTWFudWZh Y3R1cmVyIFJlZmVyZW5jZTogIiwgdGV4dGZpZWxkKCJtZmdyZWYiLCIiKSk7CglwcmludCBwKCJD b21wYW55OiAiLCB0ZXh0ZmllbGQoImNvbXBhbnkiLCIiKSk7CglwcmludCBwKCJDb250YWN0OiAi LCB0ZXh0ZmllbGQoImNvbnRhY3QiLCIiKSk7CglwcmludCBwKCJBZGRyZXNzIGxpbmUgMTogIiwg dGV4dGZpZWxkKCJhZGRyMSIsIiIpKTsKCXByaW50IHAoIkFkZHJlc3MgbGluZSAyOiAiLCB0ZXh0 ZmllbGQoImFkZHIyIiwiIikpOwoJcHJpbnQgcCgiQ2l0eTogIiwgdGV4dGZpZWxkKCJjaXR5Iiwi IikpOwoJcHJpbnQgcCgiU3RhdGU6ICIsIHRleHRmaWVsZCgic3RhdGUiLCIiKSk7CglwcmludCBw KCJaaXA6ICIsIHRleHRmaWVsZCgiemlwIiwiIikpOwoJcHJpbnQgcCgiUGhvbmU6ICIsIHRleHRm aWVsZCgicGhvbmUiLCIiKSk7CglwcmludCBwKCJFcXVpcG1lbnQ6ICIsIHRleHRmaWVsZCgiZXF1 aXAiLCIiKSk7CglwcmludCBwKCJTZXJpYWwgIzogIiwgdGV4dGZpZWxkKCJzZXJpYWwiLCIiKSk7 CglwcmludCBwKCJTZXJ2aWNlIE5lZWRlZDogIiwgdGV4dGZpZWxkKCJzdmNuZWVkZWQiLCIiKSk7 CglwcmludCBwKCJUZWNoIE5vdGVzOiAiLCB0ZXh0ZmllbGQoInRlY2hub3RlcyIsIiIpKTsKCXBy aW50IHAoIlNlcnZpY2UgUGVyZm9ybWVkOiAiLCB0ZXh0ZmllbGQoInN2Y3BlcmYiLCIiKSk7Cglw cmludCBwKCJTZXJ2aWNlIERhdGU6ICIsIHRleHRmaWVsZCgic3ZjZGF0ZSIsIiIpKTsKCXByaW50 IHAoIlBhcnRzIGluIERhdGU6ICIsIHRleHRmaWVsZCgicGFydHNpbiIsIiIpKTsKCXByaW50IHAo IlRpbWUgaW46ICIsIHRleHRmaWVsZCgidGltZWluIiwiIikpOwoJcHJpbnQgcCgiVGltZSBvdXQ6 ICIsIHRleHRmaWVsZCgidGltZW91dCIsIiIpKTsKCXByaW50IHAoIlJvdW5kIFRyaXAgTWludXRl czogIiwgdGV4dGZpZWxkKCJydG1pbnMiLCIiKSk7CglwcmludCBwKCJSb3VuZCBUcmlwIE1pbGVz OiAiLCB0ZXh0ZmllbGQoInJ0bWlsZXMiLCIiKSk7CglwcmludCBwKCJBaXJiaWxsIE91dDogIiwg dGV4dGZpZWxkKCJhYm91dCIsIiIpKTsKCXByaW50IHAoIlJldHVybiBBaXJiaWxsOiAiLCB0ZXh0 ZmllbGQoImFicnRybiIsIiIpKTsKCXByaW50IHAoIkVUQSBEYXRlOiAiLCB0ZXh0ZmllbGQoImV0 YWRhdGUiLCIiKSk7CglwcmludCBwKCJBY3Rpb24gQ29kZTogIiwgdGV4dGZpZWxkKCJhY3Rjb2Rl IiwiIikpOwoJcHJpbnQgcCgiU3RhdHVzIENvZGU6ICIsIHRleHRmaWVsZCgic3RhdHVzIiwiIikp OwoJcHJpbnQgcCgiUHJvYmxlbSBDb2RlOiAiLCB0ZXh0ZmllbGQoInByb2IiLCIiKSk7Cglwcmlu dCBwKCJDYXVzZSBDb2RlOiAiLCB0ZXh0ZmllbGQoImNhdXNlIiwiIikpOwoJcHJpbnQgcCgiQWN0 aW9uIENvZGU6ICIsIHRleHRmaWVsZCgiYWN0aW9uIiwiIikpOwoJcHJpbnQgcCgiQ29uZmlybWF0 aW9uOiAiLCB0ZXh0ZmllbGQoImNvbmYiLCIiKSk7CglwcmludCBwKCJEaXNwYXRjaCBOb3Rlczog IiwgdGV4dGZpZWxkKCJkaXNwbm90ZXMiLCIiKSk7CglwcmludCBwKHN1Ym1pdCgic2VuZCIpLCBy ZXNldCgiY2xlYXIiKSk7CglwcmludCBlbmRfZm9ybSwgaHI7Cn0K ------ =_NextPart_000_01BE9249.A06516C0 Content-Type: application/octet-stream; name="dataex8.cgi" Content-Transfer-Encoding: base64 IyEvdXNyL2Jpbi9wZXJsCnVzZSBDR0kgcXcoOnN0YW5kYXJkKTsKdXNlIFBnOwokY2dpX29iamVj dCA9IG5ldyBDR0k7CnByaW50ICRjZ2lfb2JqZWN0LT5oZWFkZXI7Cm15ICRjbnVtID0gcGFyYW0o ImN1c3RudW0iKTsKcHJpbnQgc3RhcnRfaHRtbCgiTVBTIEN1c3RvbWVyIExpc3QiKSwgaDEoIk1Q UyBDdXN0b21lciBMaXN0Iik7CmlmICgkY251bSkgewoJJGNvbm4gPSBQZzo6Y29ubmVjdGRiKCJo b3N0PWdyZWVubWFuIHBvcnQ9NTQzMiBkYm5hbWU9c2VydmljZXdvcmtzCnVzZXI9a2lya3BhdHJp Y2tqdCIpOwoJJHF1ZXJ5PSJTRUxFQ1QgY3VzdG51bSwgY3VzdG5hbWUsIGNjb250YWN0LCBjcGF5 dGVybXMsIGNtYWRkcjEsCmNtYWRkcjIsIGNtY2l0eSwgY21zdGF0ZSwgY216aXAsIGN2cGhvbmUx IGZyb20gY3VzdCB3aGVyZQpjdXN0bnVtPSckY251bSc7IjsgIyBnb2VzIHdpdGggZml4ZWQKCSRy ZXN1bHQ9JGNvbm4tPmV4ZWMoIiRxdWVyeSIpOyAKCSMkY29ubiA9IFBnOjpjb25uZWN0ZGIoImhv c3Q9Z3JlZW5tYW4gcG9ydD01NDMyIGRibmFtZT10ZXN0IHVzZXI9a2lya3BhdHJpY2tqdCIpOwoJ IyRxdWVyeT0iU0VMRUNUIGN1c3RudW0sIGN1c3RuYW1lIGZyb20gY3VzdG9tZXJzOyI7ICAjIGdv ZXMgd2l0aCBncmVlbm1hbgoJcHJpbnQgIjx0YWJsZSBib3JkZXI9MiB0ZXh0PSsyPiI7Cglwcmlu dAoiPHRyPjx0aD5jdXN0bnVtYmVyPC90aD48dGg+Y3VzdG5hbWU8L3RoPjx0aD5jb250YWN0PC90 aD48dGg+cGF5dGVybXM8L3RoPjx0aD5hZGRyMTwvdGg+PHRoPmFkZHIyPC90aD48dGg+Y2l0eTwv dGg+PHRoPnN0YXRlPC90aD48dGg+emlwPC90aD48dGg+cGhvbmU8L3RoPjwvdHI+XG4iOwoJd2hp bGUgKEByb3c9JHJlc3VsdC0+ZmV0Y2hyb3cpIHsKCgkJcHJpbnQgIjxUUj5cbiI7CgkJcHJpbnQg IjxURD4iLCAkcm93WzBdLCAiPC9URD4iOwoJCXByaW50ICI8VEQ+IiwgJHJvd1sxXSwgIjwvVEQ+ IjsKCQlwcmludCAiPFREPiIsICRyb3dbMl0sICI8L1REPiI7CgkJcHJpbnQgIjxURD4iLCAkcm93 WzNdLCAiPC9URD4iOwoJCXByaW50ICI8VEQ+IiwgJHJvd1s0XSwgIjwvVEQ+IjsKCQlwcmludCAi PFREPiIsICRyb3dbNV0sICI8L1REPiI7CgkJcHJpbnQgIjxURD4iLCAkcm93WzZdLCAiPC9URD4i OwoJCXByaW50ICI8VEQ+IiwgJHJvd1s3XSwgIjwvVEQ+IjsKCQlwcmludCAiPFREPiIsICRyb3db OF0sICI8L1REPiI7CgkJcHJpbnQgIjxURD4iLCAkcm93WzldLCAiPC9URD4iOwoJCXByaW50ICI8 L1RSPlxuIjsKCX0KCXByaW50ICI8L3RhYmxlPlxuIjsKfSBlbHNlIHsKCXByaW50IGhyLCBzdGFy dF9mb3JtOwoJcHJpbnQgcCgiV2hhdCBjdXN0b21lciBudW1iZXI6ICIsIHRleHRmaWVsZCgiY3Vz dG51bSIsIiIpKTsKCXByaW50IGVuZF9mb3JtLCBocjsKfQo= ------ =_NextPart_000_01BE9249.A06516C0--