psql check if sql script is valid
$ 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"check psql validity function
CREATE OR REPLACE FUNCTION is_sql(sql text) returns boolean
language plpgsql
AS
$$
DECLARE
exception_message text;
exception_context text;
BEGIN
BEGIN
EXECUTE E'DO $IS_SQL$ BEGINnRETURN;n' || trim(trailing E'; rn' from sql) || E';nEND; $IS_SQL$;';
EXCEPTION WHEN syntax_error THEN
GET STACKED DIAGNOSTICS
exception_message = MESSAGE_TEXT,
exception_context = PG_EXCEPTION_CONTEXT;
RAISE NOTICE '%', exception_context;
RAISE NOTICE '%', exception_message;
RETURN FALSE;
END;
RETURN TRUE;
END
$$;
-- TEST
SELECT is_sql('SELECTx'), is_sql('SELECT x');Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
