How to correctly escape characters in command-line postgresql query?

@wilmer.lemke 

To correctly escape characters in a command-line PostgreSQL query, you can use the backslash () character to escape special characters such as quotes and semicolons. Here are some examples:

1. To escape a single quote ('):

1

SELECT * FROM table WHERE column = 'It''s a test';

1. To escape a double quote ("):

1

SELECT * FROM table WHERE column = 'This is "quoted"';

1. To escape a semicolon (;):

1

SELECT * FROM table WHERE column = 'This is a ; test';

1. To escape a backslash ():

1

SELECT * FROM table WHERE column = 'This is a backslash \ test';

By using the backslash character to escape special characters, you can ensure that your PostgreSQL query is correctly interpreted by the command-line interface.