PostgreSQL dollar-quoted strings - what am I missing
a
anonymous
started a topic
about 12 years ago
[This topic is migrated from our old forums. The original author name has been removed]
trying example in thread http://www.dbvis.com/forum/message.jspa?messageID=7405
I'm still getting PostgreSQL error: [Error Code: 0, SQL State: 42601] ERROR: unterminated dollar-quoted string at or near "$$
Have variable identifier prefix/suffix to: '${' and '}$'
using:
Product: DbVisualizer Personal 8.0.10
Build: #1766 (2012/07/10 21:25)
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Version: 1.7.0_05
Java Vendor: Oracle Corporation
OS Name: Windows 7
OS Arch: amd64
OS Version: 6.1
PostgreSQL Native Driver
------------------------
Version: 9.1-902 JDBC 4
Files: postgresql.jar
Reference: http://jdbc.postgresql.org
TIA, JimPP
Re: PostgreSQL dollar-quoted strings - what am I missing
Hi Jim,
Since the CREATE FUNCTION statement includes semicolons (statement delimiters), you need to use Execute Buffer instead of Execute, or enclose the statement in SQL Block delimiters, use the @delimiter command to temporarily change the statement delimiter, or use the Procedure Editor to edit the function.
Please see these sections of the Users Guide for more info about all of these options:
http://www.dbvis.com/doc/main/doc/ug/sqlCommander/sqlCommander.html#mozTocId958847
http://www.dbvis.com/doc/main/doc/ug/sqlCommander/sqlCommander.html#mozTocId652495
http://www.dbvis.com/doc/main/doc/ug/sqlCommander/sqlCommander.html#mozTocId437790
http://www.dbvis.com/doc/main/doc/ug/procEditor/procEditor.html
I hope one of these alternatives suits your needs.
Best Regards,
Hans
a
anonymous
said
about 12 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: PostgreSQL dollar-quoted strings - what am I missing
Hans, got it. I was not using SQL block delimiters.
BTW, congratulations on great V9.0 upgrade!
-Jim
Hans Bergsten
said
about 12 years ago
[This reply is migrated from our old forums.]
Re: PostgreSQL dollar-quoted strings - what am I missing
Hi Jim,
Great that it works now, and I'm glad you like 9.0.
Best Regards,
Hans
anonymous