| From: | Federico Di Gregorio <fog(at)dndg(dot)it> |
|---|---|
| To: | psycopg(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Creating dynamically-typed tables using psycopg2's built-in formatting |
| Date: | 2019-06-14 12:40:20 |
| Message-ID: | 2f7e1339-a0aa-a269-17e1-f7c134176f45@dndg.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)digregorio(at)dndg(dot)it
DNDG srl http://dndg.it
The number of the beast: vi vi vi. -- Delexa Jones
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2019-06-14 16:07:09 | Re: Creating dynamically-typed tables using psycopg2's built-in formatting |
| Previous Message | Daniele Varrazzo | 2019-06-14 00:05:18 | psycopg 2.8.3 released |