Postgres module

split_statements

procedure · 1 overloadsince 0.27.0Source

Splits a script into its statements, skipping quoted text, dollar quotes and comments, so a ; inside them does not end a statement. Empty statements are dropped. The pieces point into sql.

split_statements :: (sql: string) -> [] string

Splits a script into its statements, skipping quoted text, dollar quotes and comments, so a ; inside them does not end a statement. Empty statements are dropped. The pieces point into sql.

Parameters

sql: string
the script to split.

Returns

[] string

See also