INSERTing rows from external file

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема INSERTing rows from external file
Дата
Msg-id alpine.LNX.2.00.1108161430480.23855@salmo.appl-ecosys.com
обсуждение исходный текст
Ответы Re: INSERTing rows from external file
Re: INSERTing rows from external file
Re: INSERTing rows from external file
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Using Postgresql as application server
Следующее
От: raghu ram
Дата:
Сообщение: Re: get old versions (8.3.8 or 8.4.1)