PostgreSQL返回选择结果并将它们添加到临时表中?

I want to select a set of rows and return them to the client, but I would also like to insert just the primary keys (integer id) from the result set into a temporary table for use in later joins in the same transaction.I want to select a set of rows and return them