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 vote127 views1 answer
Multiple left join mysql
SQL
0 vote92 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
4 votes126 views1 answer
Oracle show error line number
SQL
41 votes195 views6 answers
Alter table add column in SQL Server
SQL
1 vote88 views1 answer
Ms sql - add one hour to time
SQL
0 vote135 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote91 views1 answer
Mysql workbench search all tables
SQL
2 votes144 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote136 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
1 vote129 views1 answer
Oracle get current schema
SQL