[GENERAL] 9.6.1: INSERT with PK as serial - Mailing list pgsql-general

From Rich Shepard
Subject [GENERAL] 9.6.1: INSERT with PK as serial
Date
Msg-id alpine.LNX.2.11.1701161537580.18553@localhost
Whole thread Raw
Responses Re: [GENERAL] 9.6.1: INSERT with PK as serial
Re: [GENERAL] 9.6.1: INSERT with PK as serial
List pgsql-general
   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.

Rich


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Custom type column index - Postgres 9.1
Next
From: David Rowley
Date:
Subject: Re: [GENERAL] 9.6.1: INSERT with PK as serial