3
4

More than 3 years have passed since last update.

DBの情報をlistに格納したい

Posted at
import psycopg2
connection = psycopg2.connect("********")
cur = connection.cursor()
list = []#ちなみにこれは作れない
cur.execute("SELECT ID FROM DB;")
list = cur
print(list)

直接入れると無理みたい
curで取得できるのは「[(1),(2),(3)]」でlistの中にtupleが入っているので扱いづらい。ので、listの中にstringで追加した変数を作りたい

import psycopg2
connection = psycopg2.connect("********")
cur = connection.cursor()
list = []
cur.execute("SELECT ID FROM DB;")
for i in cur:
   list.append(str(i[0]))
print(list)

これなら[1,2,3]のように作成されるので扱いやすい

3
4
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
3
4