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
Monetize your website traffic with US
Monetize your website traffic with Me

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

Post a Comment

Archive

Populer