Breaking News: Grepper is joining You.com. Read the official announcement!

psql check if sql script is valid

Wicked Wildebeest answered on May 6, 2021 Popularity 4/10 Helpfulness 1/10

answer psql check if sql script is valid

psql check if sql script is valid

Comment

$ pgsanity good1.sql good2.sql bad.sql
bad.sql: line 1: ERROR: syntax error at or near "bogus_token"

$ find -name '*.sql' | xargs pgsanity
./sql/bad1.sql: line 59: ERROR: syntax error at or near ";"
./sql/bad2.sql: line 41: ERROR: syntax error at or near "insert"
./sql/bad3.sql: line 57: ERROR: syntax error at or near "update"

Popularity 4/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: psql script sql

Link to this answer
Share Copy Link