SQL

How to save PostgreSQL query

create or replace function count_app_users()
    returns table
            (
                total bigint
            )
    language plpgsql
as
$$
begin
    return query (
      select count(*) from app_user
    );
end;
$$;

select save as table postgres

CREATE TABLE <table name> AS (
SELECT STATEMENT
)

How to save PostgreSQL query

SELECT count(*) FROM app_user;