Re: Creating dynamically-typed tables using psycopg2's built-informatting
От
Christophe Pettus
Тема
Re: Creating dynamically-typed tables using psycopg2's built-informatting
Дата
Msg-id
CEA954F4-E4C3-4427-B85C-616CD11F8D4D@thebuild.com
Ответ на
Список
Дерево обсуждения
Creating dynamically-typed tables using psycopg2's built-in formatting Daniel Cohen <daniel.m.cohen@berkeley.edu>
Re: Creating dynamically-typed tables using psycopg2's built-informatting Christophe Pettus <xof@thebuild.com>
Re: Creating dynamically-typed tables using psycopg2's built-in formatting Daniel Cohen <daniel.m.cohen@berkeley.edu>
Re: Creating dynamically-typed tables using psycopg2's built-informatting Federico Di Gregorio <fog@dndg.it>
Re: Creating dynamically-typed tables using psycopg2's built-informatting Christophe Pettus <xof@thebuild.com>
Re: Creating dynamically-typed tables using psycopg2's built-in formatting Daniel Cohen <daniel.m.cohen@berkeley.edu>
Re: Creating dynamically-typed tables using psycopg2's built-in formatting Sebastiaan Mannem <sebastiaan.mannem@enterprisedb.com>
Re: Creating dynamically-typed tables using psycopg2's built-in formatting Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: Creating dynamically-typed tables using psycopg2's built-in formatting Daniel Cohen <daniel.m.cohen@berkeley.edu>
RE: Creating dynamically-typed tables using psycopg2's built-informatting David Raymond <David.Raymond@tomtom.com>
Re: Creating dynamically-typed tables using psycopg2's built-informatting Adrian Klaver <adrian.klaver@aklaver.com>
RE: Creating dynamically-typed tables using psycopg2's built-informatting David Raymond <David.Raymond@tomtom.com>
Re: Creating dynamically-typed tables using psycopg2's built-informatting Christophe Pettus <xof@thebuild.com>
> On Jun 13, 2019, at 13:54, 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). By "returns nothing," do you mean you get an error, or that you get zero rows? I'd connect to the database using psql and use \d to see what tables actually exist. -- -- Christophe Pettus xof@thebuild.com
В списке psycopg по дате отправления
От: Adrian Klaver
Дата:
От: Daniel Cohen
Дата: