Skip to content

Instantly share code, notes, and snippets.

@jamster10
Created May 6, 2019 19:14
Show Gist options
  • Save jamster10/8b9c7ac8d296dd1f77884f3129b02287 to your computer and use it in GitHub Desktop.
Save jamster10/8b9c7ac8d296dd1f77884f3129b02287 to your computer and use it in GitHub Desktop.
CREATE USER "dunder-mifflin" SUPERUSER;
CREATE DATABASE bookmarks OWNER "dunder-mifflin";
\c bookmarks;
create table bookmarks (
id BIGSERIAL NOT NULL PRIMARY KEY,
title VARCHAR(50) NOT NULL,
url VARCHAR(100) NOT NULL,
content VARCHAR(200)
);
insert into bookmarks (title, url, content) values ('Duobam', 'https://msu.edu', 'Morbi porttitor lore ligula.');
insert into bookmarks (title, url, content) values ('Treeflex', 'http://mac.com', 'Curabitur gravida nisi at nibh. In hac habitasse platea dictumst.');
insert into bookmarks (title, url, content) values ('Namfix', 'https://utexas.edu', 'Nulla mollis molestie lorem. Quisque ut erat. Curabitur gravida nisi at nibh. In hac habitasse platea dictumst.');
insert into bookmarks (title, url, content) values ('Redhold', 'http://wiley.com', 'Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla. Nunc purus. Phasellus in felis.');
insert into bookmarks (title, url, content) values ('Daltfresh', 'http://hhs.gov', 'Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc. Vestibulum ante ipsum primis in f.');
insert into bookmarks (title, url, content) values ('Sonair', 'https://jalbum.net', 'Nulla nisl. Nunc nisl. Duis bibendum, felis sed interdum venenatis, turpis enim blandit mi, in porttitor pede justo eu massa.');
insert into bookmarks (title, url, content) values ('Aerified', 'https://angelfire.com', 'In blandit ultrices enim. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin interdum mauris non ligula pellentesque ultrices.');
insert into bookmarks (title, url, content) values ('Ronstring', 'https://typepad.com', 'Duis bibendum. Morbi non quam nec dui luctus rutrum. Nulla tellus. In sagittis dui vel nisl.');
insert into bookmarks (title, url, content) values ('Ronstring', 'http://ocn.ne.jp', 'In hac habitasse platea dictumst. Maecenas ut massa quis augue luctus tincidunt. Nulla mollis molestie lorem. Quisque ut erat.');
insert into bookmarks (title, url, content) values ('Otcom', 'https://sciencedaily.com', 'Aliquam quis turpis eget elit sodales scelerisque. Mauris sit amet eros.');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment