How restore a PostgreSQL table from *.sql using pg_dump or psql?

postgresql dump psql
NiLL picture NiLL · Feb 24, 2012 · Viewed 40.7k times · Source

I need to restore a big table (250mb) in PostgreSQL database in console tool. How I can do this using ps_dump or psql?

Answer

Tometzky picture Tometzky · Feb 24, 2012

Just connect to database with psql and run \i /path/to/filename.sql.

Related questions

How to restore PostgreSQL dump file into Postgres databases?

I have a dump file with a .SQL extension (in fact it is a plain-text SQL file). I want to restore it into my created databases. I am using pgAdmin III, and when I use its "Restore Wizard" it does …

Read More
psql invalid command \N while restore sql

I'm trying to restore my dump file, but it caused an error: psql:psit.sql:27485: invalid command \N Is there a solution? I searched, but I didn't get a clear answer.

Read More
PostgreSQL: database restore from dump - syntax error

I'm trying to restore a PostgreSQL database by executing the SQL that pg_dump created, on an empty database. I'm getting this error: ERROR: syntax error at or near "\" LINE 5211: \. lines 5210 and 5211 read: COPY auth_group (id, name) FROM stdin; \. …

Read More