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

4 votes351 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote369 views1 answer
Sparql list all graphs
SQL
24 votes345 views4 answers
Delete db postgres
SQL
0 vote344 views1 answer
How to define a save method in ruby for sql databases
SQL
4 votes424 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote315 views1 answer
Procedures and functions in pl/sql
SQL
1 vote327 views4 answers
Between vs in sql
SQL
1 vote380 views1 answer
Mysql default port
SQL
0 vote327 views1 answer
Postgresql conectar
SQL
15 votes362 views3 answers
Postgresql change column type
SQL