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

18 votes370 views4 answers
Uninstall mysql ubuntu 18.04
SQL
1 vote349 views1 answer
How to update date add hours in postgresql
SQL
17 votes341 views4 answers
Set mysql Password
SQL
14 votes387 views2 answers
Oracle add attribute to table
SQL
0 vote369 views1 answer
Mysql grant grant option
SQL
1 vote348 views1 answer
Import sql file mysql commadn line
SQL
0 vote387 views2 answers
Insert data mysql with cmd
SQL
0 vote374 views1 answer
Mysqli last row
SQL
11 votes329 views2 answers
Having keyword sql
SQL
1 vote336 views1 answer
Oracle sql create or replace view
SQL