yokoyantech https://blog.hatena.ne.jp/yokoyantech/ 紙一重の積み重ね https://www.yokoyan.net/ Python PostgreSQL やりたいこと Python3で、PostgreSQLのsequenceを使った処理を書きたい 実行環境 PostgreSQL9.6.6 Python3.6 psycopg2.7.4 検証用シーケンス CREATE SEQUENCE "schema"."table_name_id_seq" INCREMENT 1 START 1 NO MAXVALUE NO MINVALUE NO CYCLE CACHE 1 OWNED BY "schema"."table_name"."id" ; 実装例 try: conn = psycopg2.connect( host=rds_host, databas… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.yokoyan.net%2Fentry%2F2018%2F05%2F15%2F070000" title="Python3+Psycopg2を使ってsequenceを取得する #Python3 #PostgreSQL9.6 - 紙一重の積み重ね" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2018-05-15 07:00:00 rich https://www.yokoyan.net/entry/2018/05/15/070000 1.0 100%