{"version":"1.0","provider_name":"Biomedical Data Science Laboratory","provider_url":"https:\/\/bdsl.jbnu.ac.kr\/blog","author_name":"sphong","author_url":"https:\/\/bdsl.jbnu.ac.kr\/blog\/author\/sphong\/","title":"PostgreSQL - Biomedical Data Science Laboratory","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"Roo2aRwrS1\"><a href=\"https:\/\/bdsl.jbnu.ac.kr\/blog\/postgresql\/\">PostgreSQL<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/bdsl.jbnu.ac.kr\/blog\/postgresql\/embed\/#?secret=Roo2aRwrS1\" width=\"600\" height=\"338\" title=\"&#8220;PostgreSQL&#8221; &#8212; Biomedical Data Science Laboratory\" data-secret=\"Roo2aRwrS1\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"PostgreSQL is an open source database management software widely used in scientific researches. This post describe basic usage of PostgreSQL. This includes how to install PostgreSQL in Ubuntu (linux) system, create a user and a database, and use Python (psycopg2) interface. 1. Installation Installation in Ubuntu Administrator account PostgreSQL installation create a administrator account, postgres. [&hellip;]"}