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

28 votes188 views6 answers
Foreign key
SQL
0 vote155 views1 answer
Mysql backup query
SQL
1 vote155 views2 answers
Sql where is not number
SQL
0 vote134 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
4 votes146 views2 answers
Oracle sql group by date year
SQL
1 vote141 views2 answers
Mysql select tables with name like
SQL
0 vote177 views1 answer
DATEDIFF minute postgres
SQL
0 vote108 views1 answer
Store query result in variable sql
SQL
0 vote168 views1 answer
Alter owner in PostgreSQL
SQL
0 vote144 views1 answer
Declare or use variable in snowflake
SQL