require 'pg' connection = PG::connect(:host => "127.0.0.1", :user => "mailadmin", :dbname => "db_mailbox", :port => "5432") connection.internal_encoding = "UTF-8" begin #select result = connection.exec("SELECT value FROM test_tbl03") result.each do |tuple| puts tuple['value'] end #insert result = connection.exec("insert into test_tbl03 (value) values ('abcd')") ensure connection.finish end beginとか
![[Ruby] rubyでPOP3受信して、件名だけをPostgreSQLに放り込む。 - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/48741fdf9854abbca0044cf4fc2dd04841aefcf5/backend=imagemagick;height=288;version=1;width=512/https%3A%2F%2Fproxy.goincop1.workers.dev%3A443%2Fhttps%2Fcdn.qiita.com%2Fassets%2Fqiita-fb-2887e7b4aad86fd8c25cea84846f2236.png)
