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$ BEGIN\nRETURN;\n' || trim(trailing E'; \r\n' 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');

Source: raw.githubusercontent.com

Similar codes

3 votes226 views3 answers
Order by postgres
SQL
2 votes233 views1 answer
Sqlite3 show columns name
SQL
0 vote191 views1 answer
Sql script get all stored procedures from database
SQL
10 votes238 views2 answers
Tsql merge example
SQL
-1 vote221 views3 answers
Error mysql shutdown unexpectedly
SQL
3 votes212 views1 answer
Two selects in one query
SQL
0 vote230 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
6 votes224 views6 answers
Count mysql
SQL
0 vote211 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote221 views1 answer
Mariadb datetime change to microseconds
SQL