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

-1 vote236 views3 answers
Compute age mysql
SQL
0 vote252 views1 answer
Run sql script file and changes db name in this file using c#
SQL
2 votes263 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote226 views1 answer
Create or replace view postgress
SQL
0 vote223 views1 answer
Oracle sql generate list of days
SQL
0 vote228 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote224 views1 answer
Do postgresql
SQL
0 vote227 views1 answer
Sqlite to csv statement
SQL
7 votes228 views6 answers
Group_concat mysql
SQL
0 vote242 views2 answers
Add new column after in sql
SQL