pgscript question

snorkel · Post by **snorkel** » Fri 16 Jan 2009 16:54

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

Plash · Post by **Plash** » Mon 19 Jan 2009 09:08

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.

snorkel · Post by **snorkel** » Fri 23 Jan 2009 17:37

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.