Skip to content

Instantly share code, notes, and snippets.

@kitz99
Created June 22, 2018 08:05
Show Gist options
  • Save kitz99/920528bf2d5e3080091f1bf42b425be1 to your computer and use it in GitHub Desktop.
Save kitz99/920528bf2d5e3080091f1bf42b425be1 to your computer and use it in GitHub Desktop.
$ docker exec -it goroach_master_1 ./cockroach sql --insecure
> create database blog_db;
> set database = blog_db;
> CREATE TABLE "posts" (
"id" SERIAL,
"name" STRING(100),
"category" STRING(50),
"author" STRING(50),
"created_at" TIMESTAMPTZ,
"updated_at" TIMESTAMPTZ,
PRIMARY KEY ("id")
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment