Search Postgresql Archives

Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Wed, 23 Nov 2016 08:25:38 -0700
Cc: John McKown <john.archie.mckown@xxxxxxxxx>, PostgreSQL General <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAAOuvVoEEJpM60UNyJR6DU=Ezf56a8R9yzMrzi_tDCwT88ofWQ@mail.gmail.com>
References: <CAAOuvVq-2PPmweM7MJornOk-qnedwtdUM_hHbMQhmJg=ORAJYQ@mail.gmail.com> <CAAJSdjinub7JGjZtDo7q7CnJq627O6vdnusudJ3h-QdQZVbrYQ@mail.gmail.com> <CAAOuvVqhAu=U-S6N59==mPFNMctFEiM5+-xK-JB75Rb5SrqYZw@mail.gmail.com> <CAAJSdji024ecwvCreTviPpO4KPGTw=AB=yPe1cE=NtvmTcKDMA@mail.gmail.com> <CAAOuvVrK17P9y_PpdH1vQV958nAxVnz=khD2NOMagHvLOMfNrg@mail.gmail.com> <CAAJSdjgOSYikk_y8K3afJP8zxGbZqrh8BOkrLhV8Dk4hpsqnrQ@mail.gmail.com> <CAAOuvVoEEJpM60UNyJR6DU=Ezf56a8R9yzMrzi_tDCwT88ofWQ@mail.gmail.com>

On Wed, Nov 23, 2016 at 3:46 AM, Poul Kristensen <bcc5226@xxxxxxxxx> wrote:

In the postgresql.log I get "select datname from $1".

That is expected when you parameterize a query - the query string includes parameters instead of values. What you are seeing is the "Prepare" component of a "prepare-execute". When you execute you then see something like; "execute unnamed_query ['pg_database']" (note, I'm not familiar with the exact syntax and terminology that would appear in the log file).

David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: Tom Lane

References:
- Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: Poul Kristensen
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: John McKown
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: John McKown
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: Poul Kristensen
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: John McKown
- Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
  - From: Poul Kristensen

Prev by Date: Re: max_connections limit violation not showing in pg_stat_activity
Next by Date: Re: query locks up when run concurrently
Previous by thread: Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
Next by thread: Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]