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

Поиск
Список
Период
Сортировка
От Daniel Cohen
Тема Re: Creating dynamically-typed tables using psycopg2's built-in formatting
Дата
Msg-id CAHAzoYn6a73nb_cZ-vuFiq=x0bTPyYYu9CyWmXFiLEtuhM2JTg@mail.gmail.com
обсуждение исходный текст
Ответ на 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  (Sebastiaan Mannem <sebastiaan.mannem@enterprisedb.com>)
Список psycopg
Дерево обсуждения
Hi again,

I realize the error was that I specified the name as "schema.tbl", and I think because there was a period in the name, it converted to double-quote. I tried again as just "tbl" and it worked perfectly. Thanks so much for all your help.

Best,

Danny

On Fri, Jun 14, 2019 at 9:12 AM Christophe Pettus <xof@thebuild.com> wrote:


> On Jun 13, 2019, at 13:54, Daniel Cohen <daniel.m.cohen@berkeley.edu> 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 по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: Creating dynamically-typed tables using psycopg2's built-informatting
Следующее
От: Sebastiaan Mannem
Дата:
Сообщение: Re: Creating dynamically-typed tables using psycopg2's built-in formatting