changing table owners in postgres from livecode
dochawk at gmail.com
Thu May 2 22:36:19 EDT 2013
On Thu, May 2, 2013 at 7:14 PM, Peter Haworth <pete at lcsql.com> wrote:
> Good point. The dictionary is kinda confusing on this. It says "do not
> include a semicolon at the end of the statement", then says "some" sql
> systems are capable of executing multiple statements, which presumably
> means terminating each one with a semicolon. I guess it means no semicolon
> at the end of the last statement.
Thinking of how psql does it, it must be appending a semicolon--but
an extra semicolon should be harmless, as well.
> No idea whether postgres supports multiple statements in one command.
The BEGIN/COMMIT is most definitely supported in postgres (and I think
even sqlite has rudimentary support for it)
Dr. Richard E. Hawkins, Esq.
More information about the Use-livecode