02 February 2020

How to create multiple columns in one table with a single query statement POSTGRESQL

add column in alter table how to fix it:

this is the trick in PostgreSQL

ALTER TABLE t_company ADD COLUMN
  uktp character varying(100), ADD COLUMN
  usiup character varying(100), ADD COLUMN
  utdp character varying(100), ADD COLUMN
  uakta character varying(100), ADD COLUMN
  x character varying(25), ADD COLUMN
  y character varying(25);

Then Go or execute
Share:

0 komentar:

Post a Comment

Blog Archive