Home > mailing lists

[psycopg] Parse record type into tuple - Mailing list psycopg

From	Dmytro Starosud
Subject	[psycopg] Parse record type into tuple
Date	September 5, 2017 21:40:17
Msg-id	CANC2W+A88-8b9VzEkTh1cma9ezTtvNa7Z6gK6_LL1e7udZLjFA@mail.gmail.com Whole thread Raw
Responses	Re: [psycopg] Parse record type into tuple Re: [psycopg] Parse record type into tuple
List	psycopg

Hello guys

I do following interactions with DB:

In [48]: conn = psycopg2.connect("dbname=... user=... password=...")

In [49]: cur = conn.cursor()

In [50]: cur.execute("select (1, 2)")

In [51]: cur.fetchone()

Out[51]: ('(1,2)',)

Is it possible to get that tuple parsed into python tuple in the same way array works?

In [55]: cur.execute("select array[1, 2]")

In [56]: cur.fetchone()

Out[56]: ([1, 2],)

Looks like that can be done if I register composite type for that tuple.

But I would like it to work with any tuple.

Please assist.

Thanks in advance!

Dmytro

psycopg by date:

From: Daniele Varrazzo
Date: 26 August 2017, 19:34:45
Subject: [psycopg] Psycopg 2.7.3.1 released

From: Rory Campbell-Lange
Date: 06 September 2017, 03:39:10
Subject: Re: [psycopg] Parse record type into tuple