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

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Daniel Cohen <daniel(dot)m(dot)cohen(at)berkeley(dot)edu>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in formatting
Date: 2019-06-14 16:12:10
Message-ID: CEA954F4-E4C3-4427-B85C-616CD11F8D4D@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

> On Jun 13, 2019, at 13:54, Daniel Cohen <daniel(dot)m(dot)cohen(at)berkeley(dot)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(at)thebuild(dot)com

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Daniel Cohen 2019-06-14 16:41:28 Re: Creating dynamically-typed tables using psycopg2's built-in formatting
Previous Message Adrian Klaver 2019-06-14 16:07:09 Re: Creating dynamically-typed tables using psycopg2's built-in formatting