Updated:<\/b> Thanks @johto for s\/:bar\/:foo\/. \ud83d\ude42<\/p>\n
A coworker asked about variable substitution with psql using You definitely can do things like this: But, what about something like this:<\/p>\n Unfortunately, this isn’t supported. <\/p>\n The best you could do is something pathological like:<\/p>\n Updated: Thanks @johto for s\/:bar\/:foo\/. \ud83d\ude42 A coworker asked about variable substitution with psql using \\set, and so I looked into it a bit further. You definitely can do things like this: 16:55 sdeckelmann@[local]:5432|postgres=> \\set test ‘select * from :foo … Continue reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[97,9],"tags":[339,647,337,338],"class_list":["post-1901","post","type-post","status-publish","format-standard","hentry","category-postgres","category-postgresql","tag-commandline","tag-postgres","tag-psql","tag-variables"],"_links":{"self":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/1901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/comments?post=1901"}],"version-history":[{"count":10,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/1901\/revisions"}],"predecessor-version":[{"id":3959,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/1901\/revisions\/3959"}],"wp:attachment":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/media?parent=1901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/categories?post=1901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/tags?post=1901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\\set<\/code>, and so I looked into it a bit further.<\/p>\n
\n
\n16:55 sdeckelmann@[local]:5432|postgres=> \\set test 'select * from :foo limit 10;'
\n16:56 sdeckelmann@[local]:5432|postgres=> \\set foo 'test'
\n16:56 sdeckelmann@[local]:5432|postgres=> :test
\nmyint
\n-------
\n 1
\n 2
\n 3
\n 4
\n 5
\n 6
\n 7
\n 8
\n 9
\n 10
\n(10 rows)
\n<\/code><\/p>\n
\n=> \\set test 'select * from :var limit 10;'
\n=> :test mytable
\n<\/code><\/p>\n=> \\set s 'select * from '
\n=> \\set pr ' limit 10;'
\n=> :s mytable :pr
\n=> :s test :pr
\nmyint
\n-------
\n 1
\n 2
\n 3
\n 4
\n 5
\n 6
\n 7
\n 8
\n 9
\n 10
\n(10 rows)
\n<\/code>
\n<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"