public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Raymond <[email protected]>
To: [email protected] <[email protected]>
Subject: RE: Creating dynamically-typed tables using psycopg2's built-in formatting
Date: Thu, 13 Jun 2019 21:17:16 +0000
Message-ID: <VI1PR07MB5792E382A72D40C8EF85A49887EF0@VI1PR07MB5792.eurprd07.prod.outlook.com> (raw)
In-Reply-To: <CAHAzoYnrmM2MG8MLzG0mpP-sa0TVPgi1bA9hT0P-JuXRszbuVQ@mail.gmail.com>
References: <CAHAzoYkzXi1HFE0PmY3z0qn4SRnSZLdhChPUePf-2VwTM91upg@mail.gmail.com>
	<[email protected]>
	<CAHAzoYnrmM2MG8MLzG0mpP-sa0TVPgi1bA9hT0P-JuXRszbuVQ@mail.gmail.com>

Could you let us know what version the server is, and also show a table listing? (Connect with psql and do a \d for example)


From: Daniel Cohen <[email protected]> 
Sent: Thursday, June 13, 2019 4:55 PM
To: Christophe Pettus <[email protected]>
Cc: [email protected]
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in formatting

Hi Christophe,

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). I can't tell from your message what the script should say to fix this. Thank you again!

Best,

Danny 

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]
  Subject: RE: Creating dynamically-typed tables using psycopg2's built-in formatting
  In-Reply-To: <VI1PR07MB5792E382A72D40C8EF85A49887EF0@VI1PR07MB5792.eurprd07.prod.outlook.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