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.m.co...@berkeley.edu> Sent: Thursday, June 13, 2019 4:55 PM To: Christophe Pettus <x...@thebuild.com> Cc: psyc...@postgresql.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
