Search code examples
postgresqldumppsql

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


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


Solution

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