Page 1 of 1

pgscript question

Posted: Fri 16 Jan 2009 16:54
by snorkel
Hi,
Just wondering what you would handle a script that has a create or replace function in it?
reason being there may be semi colons (;) (postgresql default statement delimiter) in the function body.

Thanks,

Snorkel

Posted: Mon 19 Jan 2009 09:08
by Plash
PgDAC can detect dollar quoting or other quoting that is used for the function body. So the function body is treated as a string literal, and semicolons inside it are ignored.

Posted: Fri 23 Jan 2009 17:37
by snorkel
Plash wrote:PgDAC can detect dollar quoting or other quoting that is used for the function body. So the function body is treated as a string literal, and semicolons inside it are ignored.
Sweet, thanks for the info.