ERROR: unterminated quoted string at or near

by

I encountered this error in liquibase and this page was one of the first search results so I guess I share my solution at this page:

You can put your whole sql in a separate file and include this in the changeset.
Its important to set the splitStatements option to false.

The whole changeset would then look like 

<changeSet author="fgrosse" id="530b61fec3ac9">
    <sqlFile path="your_sql_file_here.sql" splitStatements="false"/>
</changeSet>

I always like to have those big SQL parts (like function updates and such) in separate files.
This way you get proper syntax highlighting when opening the sql file and dont have to intermix XML and SQL in one file.

Edit: as mentioned in the comments its worth noting that the sql change supports the splitStatements option as well (thx to AndreyT for pointing that out).

More Related Contents:

  1. INSERT with dynamic table name in trigger function
  2. What are ‘$$’ used for in PL/pgSQL
  3. Truncating all tables in a Postgres database
  4. Passing user id to PostgreSQL triggers
  5. How do I get a column with consecutive, increasing numbers, without having any numbers missing?
  6. Execute a dynamic crosstab query
  7. Is there a way to disable function overloading in Postgres
  8. Refresh a materialized view automatically using a rule or notify
  9. Can I make a plpgsql function return an integer without using a variable?
  10. PostgreSQL function returning multiple result sets
  11. Dynamic SQL (EXECUTE) as condition for IF statement
  12. SELECT raises exception in PL/pgSQL function
  13. Test for null in function with varying parameters
  14. Return SETOF rows from PostgreSQL function
  15. Error when setting n_distinct using a plpgsql variable
  16. Postgres FOR LOOP
  17. Dynamically generate columns for crosstab in PostgreSQL
  18. Function to loop through and select data from multiple tables
  19. Postgresql insert trigger to set value
  20. SQL Sub queries in check constraint
  21. Cursor based records in PostgreSQL
  22. Select from a table variable
  23. Is there a way to disable updates/deletes but still allow triggers to perform them?
  24. Hashing a String to a Numeric Value in PostgreSQL
  25. PostgreSQL – set a default cell value according to another cell value
  26. Loop on tables with PL/pgSQL in Postgres 9.0+
  27. plpgsql error “RETURN NEXT cannot have a parameter in function with OUT parameters” in table-returning function
  28. Loop through columns of RECORD
  29. Format specifier for integer variables in format() for EXECUTE?
  30. How do I temporarily disable triggers in PostgreSQL?

Leave a Comment