Search Postgresql Archives

Re: 9.6.1: INSERT with PK as serial

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 17 January 2017 at 12:44, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
>   I have a table with the primary key type of serial. The initial data load
> has 40 lines, and each has a value for every column including sequential
> integers from 1 through 40 for the data. When I try to read it in using
> 'psql -d <database_name> -f <filename.sql>' I get a syntax error at the
> second word in the string that is column 2. The error message does not print
> the integer PK. If it matters, I have all 14 columns specified but not
> explicitly named in the INSERT INTO command.
>
>   I've looked in the manual without learning how to INSERT data in a table
> with a serial PK and need to learn how to do this.

You may have more luck getting an answer if you include the statement
causing the problem.

If you're not specifying the column names, then the VALUES list must
have the same number of values, in the same order as the columns
defined on the table.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux