INSERTing rows from external file

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: INSERTing rows from external file
Date: 2011-08-16 21:34:27
Message-ID: alpine.LNX.2.00.1108161430480.23855@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a file with 5500 rows formated as 'INSERT INTO <table>
(column_names) VALUES <values>;' that I thought I could read using psql from
the command line. However, the syntax, 'psql <database_name> < filename.sql'
throws an error at the beginning of the first INSERT statement.

In the INSERT manual page I see no example or other insight on adding a
large number of rows to a table from an external .sql file. Please point me
to the reference on how to do this.

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message raghu ram 2011-08-16 21:37:36 Re: get old versions (8.3.8 or 8.4.1)
Previous Message Chris Travers 2011-08-16 21:04:11 Re: Using Postgresql as application server