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

5 votes273 views1 answer
Oracle list days between two dates
SQL
0 vote260 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote253 views1 answer
How to fix mysql stop unexpectedly
SQL
7 votes259 views1 answer
Safe mode mysql
SQL
0 vote265 views1 answer
Insert into select with group by
SQL
0 vote227 views1 answer
Deleted table in sql trigger
SQL
2 votes261 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
1 vote319 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote212 views1 answer
Sqlalchemy filter relationship
SQL
6 votes284 views2 answers
Postgresql database url
SQL