bugged.be

"Think outside the [B0X]"
Icon

sample table for postgresql

Postgresql way to add incremental id:

CREATE TABLE public.test
(
   id serial, 
   key varchar(50),
   value varchar(50)
) 
WITH (
  OIDS = FALSE
)
;

Category: Sql, Uncategorized

Tagged: