Skip to content

Instantly share code, notes, and snippets.

-- Update column lengths
ALTER TABLE hits RENAME COLUMN "ipaddress" TO ipaddress_old;
ALTER TABLE hits ADD COLUMN "ipaddress" varchar(15);
UPDATE hits SET "ipaddress" = ipaddress_old;
ALTER TABLE hits DROP COLUMN ipaddress_old;
ALTER TABLE hits RENAME COLUMN "servername" TO servername_old;
ALTER TABLE hits ADD COLUMN "servername" varchar(32);
UPDATE hits SET "servername" = servername_old;
ALTER TABLE hits DROP COLUMN servername_old;

Keybase proof

I hereby claim:

  • I am ryanflemingolo on github.
  • I am rfleming (https://keybase.io/rfleming) on keybase.
  • I have a public key ASCTJeYU5awuQ1bwwn9D2rNdj4K2eeC-AlwIi3nd5LWykAo

To claim this, I am signing this object: