Re: [GENERAL] Feature request - psql --quote-variable

2017-03-09 Thread Caleb Cushing
Thank you. Apparently I never saw this response, for some reason... So reading that leaves me confused on one point, which is the right way to do it if you're inserting an integer? would this be right? is there a difference between the single and double quotes here? (presume id is a bigint) `ins

Re: [GENERAL] Feature request - psql --quote-variable

2017-03-07 Thread David G. Johnston
On Tue, Mar 7, 2017 at 1:29 PM, Pavel Stehule wrote: > > > 2017-03-07 21:04 GMT+01:00 Caleb Cushing : > >> Thank you. Apparently I never saw this response, for some reason... >> >> So reading that leaves me confused on one point, which is the right way >> to do it if you're inserting an integer?

Re: [GENERAL] Feature request - psql --quote-variable

2017-03-07 Thread Pavel Stehule
2017-03-07 21:04 GMT+01:00 Caleb Cushing : > Thank you. Apparently I never saw this response, for some reason... > > So reading that leaves me confused on one point, which is the right way to > do it if you're inserting an integer? would this be right? is there a > difference between the single a

Re: [GENERAL] Feature request - psql --quote-variable

2017-02-21 Thread Pavel Stehule
Hi 2017-02-21 15:19 GMT+01:00 Caleb Cushing : > recently while exploring this problem http://stackoverflow.com/q/ > 40945277/206466. I decided to go with the docker container approach of a > shell script. > > I realized that postgres' variables aren't quoted either, which results > in me quoting

[GENERAL] Feature request - psql --quote-variable

2017-02-21 Thread Caleb Cushing
recently while exploring this problem http://stackoverflow.com/q/40945277/206466. I decided to go with the docker container approach of a shell script. I realized that postgres' variables aren't quoted either, which results in me quoting them with bash, to help avoid accidents, and even then I'm