How to transfer from place to plase without backup/restore

Is it possible to transfer database from one place to another without making
backup from the source and restore at the target?

I mean I want to copy the files as they are at the source to the target?
What else I must do, so I can attach them to the target PostgreSQL database?

Also I'm creating stored procedure and it is returning me recordset, but I
can't named it, it gets random names - Unnamed Recordset <number>. Is there
a way to name give a specific name to this recordset?

Hristo Filipov