What file formats can be restored using pg_restore on PostgreSQL?
Exactly one file format is supported by pg_restore: the custom PostgreSQL dump formats from pg_dump -F c (custom), -F d (directory) and -F t (tar). Notably it cannot restore -F s (SQL) format dumps, which must be passed to psql -f instead.

If you want to load data, you probably want the \copy command from psql or the server-backend COPY command. It can load a variety of CSV-like data.

There are also external loader and ETL tools that can do more, e.g. pgloader, Talend Studio, Pentaho Kettle, CloverETL, etc.