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

0 vote153 views1 answer
Mysql date only no time
SQL
1 vote163 views1 answer
Sql select table header
SQL
0 vote151 views1 answer
How to import sqlite driver class in java using maven
SQL
7 votes157 views2 answers
Mysql check db size
SQL
2 votes144 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote151 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote147 views1 answer
Sql file in postgres with pgadmin
SQL
5 votes155 views3 answers
Sql make column nullable
SQL
3 votes186 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote170 views1 answer
Least spark sql
SQL