How to import existing *.sql files in PostgreSQL 8.4?

postgresql import
Badr picture Badr · Aug 3, 2010 · Viewed 171.7k times · Source

I am using PostgreSQL 8.4, and I have some *.sql files to import into a database. How can I do so?

Answer

Bolo picture Bolo · Aug 3, 2010

From the command line:

psql -f 1.sql
psql -f 2.sql

From the psql prompt:

\i 1.sql
\i 2.sql

Note that you may need to import the files in a specific order (for example: data definition before data manipulation). If you've got bash shell (GNU/Linux, Mac OS X, Cygwin) and the files may be imported in the alphabetical order, you may use this command:

for f in *.sql ; do psql -f $f ; done

Here's the documentation of the psql application (thanks, Frank): http://www.postgresql.org/docs/current/static/app-psql.html

Related questions

invalid byte sequence for encoding "UTF8"

I'm trying to import some data into my database. So I've created a temporary table, create temporary table tmp(pc varchar(10), lat decimal(18,12), lon decimal(18,12), city varchar(100), prov varchar(2)); And now I'm trying to import the data, copy tmp from …

Read More
How do I import modules or install extensions in Postgres 8.4?

I'm trying to import several modules that come bundled with 8.4.1 postgres, and all the commands to do so (such as contrib.import etc) do not work or cannot be found. Please help me.

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