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

Поиск
Список
Период
Сортировка
От Federico Di Gregorio
Тема Re: Creating dynamically-typed tables using psycopg2's built-informatting
Дата
Msg-id 2f7e1339-a0aa-a269-17e1-f7c134176f45@dndg.it
обсуждение исходный текст
Ответ на Re: Creating dynamically-typed tables using psycopg2's built-in formatting  (Daniel Cohen <daniel.m.cohen@berkeley.edu>)
Список 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 по дате отправления:

Предыдущее
От: Daniele Varrazzo
Дата:
Сообщение: psycopg 2.8.3 released
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Creating dynamically-typed tables using psycopg2's built-informatting