Menu
In PgAdmin III, when I copy value from returned grid and paste it into the query text, it appears there in double quotes. But to use it in query, in where clause for example, it has to be marked with apostrophe. So I have to replace quotes with apostrophe. It is rather weird for me that I always have to do so. Why it is designed in such strange way? This is a kind of stupid theoretical question, I do not expect any practical answers :)
268
Quotation marks around single words can occasionally be used for emphasis, but only when quoting a word or term someone else used. Usually, this implies that the author doesn't agree with the use of the term. He said he was “working”; it looked to me like he was procrastinating.
To reinforce your ideas: The main reason to quote material in your speech is to reinforce your words. A quotation offers a second voice that echoes your thoughts, beliefs, and claims. They said it better: Quotations provide a better way of saying things. They give you a more concise, memorable phrasing for an idea.
Use a formatted string literal to add double quotes around a variable in Python, e.g. result = f'"{my_var}"' . Formatted string literals let us include variables inside of a string by prefixing the string with f .
You can customize the quoting character, by following the following steps.
It should work, you may need to close and open PgAdmin-III
EDIT: For Mac OS X the option could be found in pgAdmin3 > Preferences > Query tool > Results grid
158
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
