RE: Creating dynamically-typed tables using psycopg2's built-in formatting

Could you let us know what version the server is, and also show a table listing? (Connect with psql and do a \d for example)

From: Daniel Cohen <daniel(dot)m(dot)cohen(at)berkeley(dot)edu>
Sent: Thursday, June 13, 2019 4:55 PM
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in formatting

Hi Christophe,

Thanks so much for your response. The uppercase --> lowercase fix worked for the types, but I'm still only getting tables that can be searched by double-quotations (i.e. > SELECT * FROM tbl; returns nothing, but > SELECT * FROM "tbl"; returns the table I uploaded). I can't tell from your message what the script should say to fix this. Thank you again!

Best,

Danny