should help you out Is this a SQL dump of the backup sort that you create via a DUMP or BACKUP statement? If so the answer is pretty much no. It's essentially a snapshot of the physical structure of the database. You need to restore/load the dump/backup to an operable database before you can do anything with it.
This might help you MyDumpSplitter is a tool that uses Linux commands like sed to extract one table from a larger SQL dump file. However, extracting one column from that table is harder, since the INSERT statements contain full rows.
wish helps you The error message says, that you can't restore the file using pg_restore because, as you mentioned, it's simply a SQL file. The suggested tool, psql, is used to execute random sql, and can be also fed an SQL file via stdin or as a parameter.