dialogbox/gist:038b9e3bdf303d030f7dd4a9cb1b03e7

Created July 21, 2016 07:30

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dialogbox/038b9e3bdf303d030f7dd4a9cb1b03e7.js"></script>
Save dialogbox/038b9e3bdf303d030f7dd4a9cb1b03e7 to your computer and use it in GitHub Desktop.

Download ZIP

Vim ex command to add type specifier to all string constant in PostgreSQL.

Raw

gistfile1.txt

:%s/\('.\{-}'\)\(\s*\)\(::\)\@!/\1::text\2/g

Author

dialogbox commented Jul 21, 2016

It converts select 'aaa'; to select 'aaa'::text;.

Author

dialogbox commented Jul 22, 2016

:%s/\('\(''\|[^']\)*'\)\(\s*\)/\1::text\3/g

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment