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 vote343 views1 answer
Xampp import sql file command line
SQL
0 vote349 views1 answer
To change the database owner in SQL server
SQL
0 vote322 views1 answer
Sql min
SQL
0 vote337 views1 answer
Alter table fulltext
SQL
2 votes342 views1 answer
Sql create database
SQL
2 votes362 views1 answer
Flask sqlalchemy boolean field
SQL
3 votes321 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote324 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote345 views1 answer
Oracle running queries sql
SQL
0 vote328 views1 answer
Check index sql server
SQL