0

I followed a tutorial to create a PostgreSQL lookup table with the following schema:

CREATE TABLE public.link_categories
(
 id integer NOT NULL DEFAULT   nextval('link_categories_id_seq'::regclass),
 name character varying(16) NOT NULL,
 description text,
 CONSTRAINT link_categories_pkey PRIMARY KEY (id)
)
WITH (
 OIDS=FALSE
);
ALTER TABLE public.link_categories
 OWNER TO postgres;

As I understand it, the first field is a numerical "sequence" key that doesn't need to be populated; it just automatically fills with numerals as I add or delete rows.

I want to fill the second field with data from a spreadsheet, and I have nothing to put in the third field at the moment.

So I copied the one field I want to import into a new spreadsheet, then added a field on either side of it. So I have a three-column table with data in the center column only. I then saved it as a CSV file.

When I try to import it, I get the following error:

WARNING: null value in column "id" violates non-null constraint

How can I fill this table with data from one CSV file, using PostgreSQL 9.5 and pgAdmin III?

2 Answers2

0

I assume you are using COPY?

You can specify the columns to insert. In this case, you would need to specify the three columns that are in the CSV (in the same order). Otherwise it will assume all columns.

khampson
  • 14,700
  • 4
  • 41
  • 43
  • No, I used IMPORT. I'm just learning PostgreSQL, and I hadn't really learned about COPY yet. I'll check it out. –  Oct 31 '15 at 00:15
-1

I see here, the guy is doing something similar, but using the serial data type. Maybe give that a shot.

Auto increment SQL function

Community
  • 1
  • 1
jwebster
  • 628
  • 2
  • 10
  • 20
  • 1
    This will not help. `SERIAL` are not true types -- simply syntactic sugar for regular sequences. See [this Postgres doc](http://www.postgresql.org/docs/current/static/datatype-numeric.html#DATATYPE-SERIAL) for more info. The issue is not with the table definition, but the insertion/copy. – khampson Oct 31 '15 at 00:12