dev-resources.site

for different kinds of informations.

Escape quotes correctly when using psql via docker in bash

Published at

11/18/2024

Categories

bash

quote

escape

shell

Author

zaphoddont

Main Article

https://dev.to/zaphoddont/escape-quotes-correctly-when-executing-sql-via-docker-in-bash-1fa5

Categories

4 categories in total

Author

10 person written this

Escape quotes correctly when using psql via docker in bash

docker compose exec site bash -c 'PGPASSWORD=***** psql -Ufoo -d bar \
  -h example.com -x -c "select qux, date(xyzzy) from tabley \
  where field in(1, 2, 3) and that_time > '"'"'2024-11-18'"'"' \
  order by that_time;"'

Explanation:

'"'"' is the Quoteception operator. When used in the middle of a single quoted string, it:

' Ends the single quoted string
" Starts a new double quoted string
' Containing only one single quote
" Ends the double quoted string
' Starts the next single quoted string

Or described another way:

echo 'Embedded single quote is here: '"'"' did you see it?'

echo 'Embedded single quote is here: ' \
"'"                                    \
' did you see it?'

Outputs:

Embedded single quote is here:  '  did you see it?

shell Article's

30 articles in total

Poor man's parallel in Bash

Ergonomic Pyhon Text Piping Solution for Linux Shell with pypyp and uv

Become a Bash Scripting Pro in 10 Minutes: A Quick Guide for Beginners

Final Bash Script Series Mastering Remote Server Management and Web App Deployment

kkTerminal —— A terminal for Web SSH connection

The Complete Guide to Bash Commands

Navigating TC39 Proposals: From Error Handling to Iterator.range

Introducing TheShell: A Game-Changer in LivinGrimoire

Pick Files from a List for Git Add and Stash Directly in Your Terminal

Start Shell Programming: A Beginner's Guide ⚙ [Part-I]

Pytest Fish shell autocompletion

Discover File Splitter & Merger: A Revolutionary Tool for Managing Large Files

🚀 RazzShell v1.0.1 is Here: Plugin Support, Enhanced Job Management, and More! 🌟

ps, kill -9 PID

Escape quotes correctly when using psql via docker in bash

currently reading

Bash vs. Shell: The Ultimate Comparison

Search and Sync Your Shell History With Atuin

Building a (somewhat) intelligent agent

Environment Management in Bash: Unlocking the Secrets of the Shell

3 Must-Know File Permissions and Ownership Commands

Ask Git to Show a Method

DEV OPS JOURNEY

Unlock the Secrets of Your Command Line with the History Command

Mastering Text Processing with Grep, Sed, Awk, Cut, and Sort

Shell Special Variables and Execution Environment

Spice up Your Terminal With a Todo Reminder Using Starship Prompt and iZiDo Bash Script

Introducing RazzShell: A Customizable Unix Shell for Modern CLI Users

File Management in Bash : Commands and Examples

Featured ones:

abubakersiddique761