restoring a table from sql file in postgresql through Windows Command prompt Im trying to restore an sql file which contains the dumpf a table (with COPY commands) into a table into the database, it would be great if someone could share an example, as the pg_restore doesn't help much in this regard. A link would do as well.

Further information: Through the psql command line client I tried to first access the database and then execute the method presented by @a_horse _with_no_name; but nothing seemed to happen, it just went on to show the next prompt; but there was no change in the backend(data was not inserted into the database). I may be doing something grossly wrong here, just got started with PostgreSQL. :)
If your dump file contains COPY statements, then it's a SQL dump which is restored using psql as explained in the manual. 

psql dbname &lt; your_dump_file.sql


More examples are in the manual.