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 vote219 views1 answer
Dual in db2
SQL
0 vote196 views1 answer
Update one column from another column in same table
SQL
0 vote182 views1 answer
Ms sql database data size
SQL
0 vote190 views1 answer
Install mysql for fedora 34
SQL
0 vote193 views1 answer
Prepared statement mysql java delete selected rows
SQL
1 vote208 views1 answer
Postgres convert date to string
SQL
2 votes212 views1 answer
Oracle apex who is connected
SQL
53 votes597 views6 answers
How to install mysql ubuntu
SQL
0 vote185 views1 answer
Oracle tablespace autoextend
SQL
0 vote193 views1 answer
Postgresql stored procedure update table values
SQL