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 vote304 views1 answer
Local sql server
SQL
0 vote322 views1 answer
Vowels in sql
SQL
0 vote319 views1 answer
Mysql root localhost run
SQL
0 vote277 views0 answer
SQL
0 vote329 views1 answer
What does leave do in mysql
SQL
11 votes320 views3 answers
Change column name sql server management studio
SQL
17 votes301 views6 answers
Mysql import sql file
SQL
1 vote316 views1 answer
Oracle sql create view
SQL
0 vote340 views4 answers
Sql rownum
SQL
0 vote320 views1 answer
Mysql export and import
SQL