I need to select certain fields from several databases and populate data into PostgreSQL with a new data schema. Where should I start?

I installed Postgres and set up the data schema. The source of the data are from several external places including databases and hard drives. I need to copy certain fields from the database and save them in Postgres tables. What is the best workflow to do this? Any guidance and tutorials are welcome, thank you very much!