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

[Poul Kristensen]

Solution:

C is able to compile with an embedded shell script.
So a small C program with an argument being the user passed to the shell
script it succeded succesfully.
I am aware that it could be my question was not specifically relevant to
Postgresql! :)
It took a while to solve. :)

Thanks

Poul


2016-11-23 21:31 GMT+01:00 Poul Kristensen <bcc5...@gmail.com>:

> My goal is to grap a user from the OS and and substitute the grapped user
> - to be the owner of the database - in the sql commands
> e.g using shell-script substitution syntax:
>        create user ${user} with login;
>        create tablespace ${user} location '/path/${user)';
>        create database ${user} owner ${user} on tablespace ${user};
> I would be surpriced if this should not be possible using gnu gcc but I
> might be wrong. It is just a question of figurering out way to do this.
> http://zetcode.com/db/postgresqlc/ has an example of how to do this using
> integer as argument on
> the commandline.
> Do you have a hint of the substitution syntax to be used in gnu gcc.
>
> Thanks.
>
> /Poul
>
>
>
> 2016-11-23 16:44 GMT+01:00 Tom Lane <t...@sss.pgh.pa.us>:
>
>> "David G. Johnston" <david.g.johns...@gmail.com> writes:
>> > 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.
>>
>> It looks like Poul is hoping to use a parameter as a table name,
>> which doesn't work.  Parameters can only represent values (constants).
>>
>>                         regards, tom lane
>>
>
>
>
> --
> Med venlig hilsen / Best regards
> Poul Kristensen
> Linux-OS/Virtualizationexpert and Oracle DBA
>



-- 
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA