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

[David G. Johnston]

On Wed, Nov 23, 2016 at 3:46 AM, Poul Kristensen <bcc5...@gmail.com> wrote:

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

​That is expected when you parameterize a query - the query string includes
parameter​s 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.