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

2 votes208 views2 answers
Spring where to put the data sql
SQL
-1 vote183 views1 answer
Export mysql table to file
SQL
0 vote198 views1 answer
Sql select sum group by id laravel join
SQL
1 vote152 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote188 views1 answer
Oracle last connection
SQL
20 votes215 views3 answers
How to open postgresql in mac
SQL
0 vote210 views1 answer
How to find lowest in sql
SQL
0 vote191 views1 answer
RowDataPacket
SQL
1 vote207 views1 answer
How to delete data from sql database in android
SQL
0 vote194 views1 answer
Interview experience as a call?
SQL