Demo

SQL — 获取所有用户的SQL

OPai

# fetch_user
// 获取所有用户
// 用户表名为: are_you_here

Code


CREATE OR REPLACE FUNCTION fetch_user()
RETURNS TABLE (
    id INTEGER,
    username VARCHAR,
    email VARCHAR,
    created_at TIMESTAMP
) AS $$
BEGIN
    RETURN QUERY
    SELECT 
        a.id,
        a.username,
        a.email,
        a.created_at
    FROM 
        are_you_here a;
END;
$$ LANGUAGE plpgsql;