Postgres Pro
Downloads
Home   >   mailing lists

Re: How to ensure column names are double quoted while using execute format when building a stored procedure? - Mailing list pgsql-general

From David G. Johnston
Subject Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Date
Msg-id CAKFQuwYF+_1NeaHu2yKSYbMqP3pDADM6p72q_u1JrqKxr4O8eA@mail.gmail.com
Whole thread Raw
In response to Re: How to ensure column names are double quoted while using execute format when building a stored procedure?  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: How to ensure column names are double quoted while using execute format when building a stored procedure?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-general
Tree view
On Thu, Dec 16, 2021 at 2:11 PM Shaozhong SHI <shishaozhong@gmail.com> wrote:
When I used SQL identifier, it stopped working.  The command line gets interpreted as following:

insert into stats select "1" as id, 'count of nulls in "UNIQUE_REFERENCE_NUMBER"' as checks, count("""UNIQUE_REFERENCE_NUMBER""") from points_of_interest."pointx_v2_National_Coverage_Sep21" where """UNIQUE_REFERENCE_NUMBER""" is null

By using the correct type specification at each variable insertion you can get this to work.

Either do trial-and-error or actually reason through what is happening at each position and why it is either correct or wrong (build up the query in parts if that makes things easier).

David J.

pgsql-general by date:

Previous
From: Shaozhong SHI
Date:
Subject: Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Next
From: Shaozhong SHI
Date:
Subject: Re: How to ensure column names are double quoted while using execute format when building a stored procedure?