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
обсуждение исходный текст
Ответ на 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  (Daniel Cohen <daniel.m.cohen@berkeley.edu>)
Список psycopg

> 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
tablesthat can be searched by double-quotations (i.e. > SELECT * FROM tbl; returns nothing, but > SELECT * FROM "tbl";
returnsthe 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
Дата:
Сообщение: Re: Creating dynamically-typed tables using psycopg2's built-informatting
Следующее
От: Daniel Cohen
Дата:
Сообщение: Re: Creating dynamically-typed tables using psycopg2's built-in formatting