public inbox for [email protected]  

help / color / mirror / Atom feed

From: Daniel Cohen <[email protected]>
To: Christophe Pettus <[email protected]>
Cc: [email protected]
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in formatting
Date: Fri, 14 Jun 2019 09:41:28 -0700
Message-ID: <CAHAzoYn6a73nb_cZ-vuFiq=x0bTPyYYu9CyWmXFiLEtuhM2JTg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAHAzoYkzXi1HFE0PmY3z0qn4SRnSZLdhChPUePf-2VwTM91upg@mail.gmail.com>
	<[email protected]>
	<CAHAzoYnrmM2MG8MLzG0mpP-sa0TVPgi1bA9hT0P-JuXRszbuVQ@mail.gmail.com>
	<[email protected]>

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 <[email protected]> wrote:

>
>
> > On Jun 13, 2019, at 13:54, Daniel Cohen <[email protected]>
> 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
>    [email protected]
>
>

view thread (13+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Creating dynamically-typed tables using psycopg2's built-in formatting
  In-Reply-To: <CAHAzoYn6a73nb_cZ-vuFiq=x0bTPyYYu9CyWmXFiLEtuhM2JTg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox