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 vote295 views2 answers
Mysql multiply
SQL
0 vote322 views3 answers
Remove folders from remote git
SQL
0 vote300 views1 answer
Mysql update from n to 100
SQL
34 votes368 views6 answers
Alter table add foreign key mysql
SQL
1 vote310 views1 answer
Postgresql create table with timestamp
SQL
1 vote319 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote303 views1 answer
What is the difference between now() and current_date()?
SQL
1 vote360 views2 answers
Laravel jwt generate token
SQL
18 votes307 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote314 views2 answers
How to get the date from datetime in mysql
SQL