Python regex to match quoted string with escaped single quotes
<p>I was using this pattern to match single quoted strings in parser:</p>

<pre><code>"'.+?'"
</code></pre>

<p>But I need regex that can find single quoted string with postgres like escape of single qoutes (doubling single qoutes). Need to match something like this:</p>

<pre><code>"'first', 'sec''ond', 't''hi''rd'"
</code></pre>

<p>I want to find shortest matches for strings that start and end with single single quotes, so the string above would mean 3 substrings:</p>

<pre><code>'first'
'sec''ond'
't''hi''rd'
</code></pre>