Getting undefined when executing signUp function

I am trying to return a particular response when a data is inserted in postgresql. The query works perfectly, Inserts data into DB but before returning a response it prints undefined. Kindly check the code below.

async function signUp(info) {
    const {
        firstName,
        lastName,
        address,
        email,
        phoneNumber,
        password,
        city,
        postal_code,
    } = info;

    console.log("only info: ", phoneNumber);

    const queryInsertNewUser = `INSERT INTO public."Users"(
        "First_Name", "Email", "Mobile", "Address", "User_Type", "Last_Name", "password", "city","postal_code")
        VALUES ('${firstName}', '${email}', '${phoneNumber}', '${address}', 'Customer', '${lastName}', '${password}','${city}','${postal_code}')
        RETURNING user_id;`;



    client.query(queryInsertNewUser, (err, result) => {
        if (!err) {
            if (result.rowCount == 1) {
                console.log("User registered.");
                return {
                    status: "Success",
                    msg: "User Registered Successfully",
                    user_id: result.rows[0].user_id,
                };
            } else {
                console.log("Not Registered.");
                return {
                    status: "Error",
                    msg: "Could not register user. Call Developer.",
                };
            }
        } else {
            console.log(err);
        }
    });
}


app.post("/signup", async(req, res) => {
    const { email } = req.body;
    const data = await signUp(req.body);
    console.log(data);
});

I tried shortening the code, tried async/await still does not work. If I remove the client.query part of signUp method and replace it with return " hello". the Console.log prints hello.

Try below code, see if it helps.

async function signUp(info) {
    try {
        const {
            firstName,
            lastName,
            address,
            email,
            phoneNumber,
            password,
            city,
            postal_code,
        } = info;
    
        console.log("only info: ", phoneNumber);
    
        const queryInsertNewUser = `INSERT INTO public.Users(
    First_Name, Email, Mobile, Address, User_Type, Last_Name, password, city,postal_code)
    VALUES ($1, $2, $3, $4, 'Customer', $5, $6, $7, $8)
    RETURNING user_id;`;
    
        const params = [firstName, email, phoneNumber, address, lastName, password, city, postal_code]
    
        const result = await client.query(queryInsertNewUser, params);
        console.log("Result here", result)
        if (result) { // OR (result && result.rowCount)
            return {
                status: "Success",
                msg: "User Registered Successfully",
                user_id: result.rows[0].user_id,
            }
        }
        console.log("Not Registered.");
        return {
            status: "Error",
            msg: "Could not register user. Call Developer.",
        }
    } catch (error) {
        console.error("Error", error)
        return {
            status: false
        }
    }
}

If you want to use callback for query then try changing it like below, but I'll suggest to move it to Promise

client.query(queryInsertNewUser, (err, result) => {
    if (err) {
        console.log(err);
        return {
            status: false
        }
    }
    if (result && result.rowCount) {
        console.log("User registered.");
        return {
            status: "Success",
            msg: "User Registered Successfully",
            user_id: result.rows[0].user_id,
        };
    } else {
        console.log("Not Registered.");
        return {
            status: "Error",
            msg: "Could not register user. Call Developer.",
        };
    }
});