Re: INSERTing rows from external file

On Tue, Aug 16, 2011 at 2:34 PM, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
>  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.

What kind of error?
>
>  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.

Do you get the same error by running psql interactively and typing \i
filename.sql?

Best Wishes,
Chris Travers