Date: Tue, 13 Jul 2021 15:02:43 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: psycopg@postgresql.org
Subject: Re: New user questions
In-Reply-To: <36d964b4-e04b-5fdf-9b21-d3bf80a3505d@aklaver.com>
Message-ID: <alpine.LNX.2.20.2107131457030.11509@salmo.appl-ecosys.com>
References: <alpine.LNX.2.20.2107131228540.11509@salmo.appl-ecosys.com>
 <36d964b4-e04b-5fdf-9b21-d3bf80a3505d@aklaver.com>
User-Agent: Alpine 2.20 (LNX 67 2015-01-07)
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
Archived-At: 
 <https://www.postgresql.org/message-id/alpine.LNX.2.20.2107131457030.11509%40salmo.appl-ecosys.com>
Precedence: bulk

On Tue, 13 Jul 2021, Adrian Klaver wrote:

> Triple quoting is used when the statement extends across more then one
> line. Pair of double quotes is used for single line statement, especially
> when there are single quoted values in the statement.

Adrian,

That makes sense: the statements are treated as comments. I hadn't thought
of them that way.

>> 2) How do I write a cursor execute UPDATE statement where the columns and
>> values to be updated can be single or multiple and the values passed into
>> the method from the tkinter widgets? Are there examples from which I can
>> learn?
>
> There are several ways to read the above.
> Send some examples of what you want to do.

Here's a template:

update contacts
set 
where
;

The contacts table has these attributes:
person_nbr   | integer
act_date     | date
act_type     | character varying(12)
notes        | text
next_contact | date

Could be a changed next_contact date, or notes, or both.

Other tables need updating; for example, a new job title for a person or a
new web site for a company.

Thanks,

Rich