Re: Creating dynamically-typed tables using psycopg2's built-informatting - Mailing list psycopg

From Federico Di Gregorio
Subject Re: Creating dynamically-typed tables using psycopg2's built-informatting
Date
Msg-id 2f7e1339-a0aa-a269-17e1-f7c134176f45@dndg.it
Whole thread Raw
In response to Re: Creating dynamically-typed tables using psycopg2's built-in formatting  (Daniel Cohen <daniel.m.cohen@berkeley.edu>)
List psycopg
On 6/13/19 10:54 PM, Daniel Cohen wrote:
> 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!

 From psql use the "\d" command to list all tables and check their 
names. Send the output here so that we can help you understand why your 
qury doesn't do what you expect.

federico

-- 
Federico Di Gregorio                         federico.digregorio@dndg.it
DNDG srl                                                  http://dndg.it
                       The number of the beast: vi vi vi. -- Delexa Jones



psycopg by date:

Previous
From: Daniele Varrazzo
Date:
Subject: psycopg 2.8.3 released
Next
From: Adrian Klaver
Date:
Subject: Re: Creating dynamically-typed tables using psycopg2's built-informatting