Skip to content

Instantly share code, notes, and snippets.

@springmeyer
Created July 11, 2011 18:26
Show Gist options
  • Save springmeyer/1076451 to your computer and use it in GitHub Desktop.
Save springmeyer/1076451 to your computer and use it in GitHub Desktop.
world_merc=# alter table world_merc add column blank text;
ALTER TABLE
world_merc=# select blank from world_merc limit 2;
blank
-------
(2 rows)
world_merc=# select count(*) from world_merc where blank is null;
count
-------
245
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment