Skip to content

Instantly share code, notes, and snippets.

CREATE INDEX CONCURRENTLY "index_poi_on_location" ON "poi" USING gist (geography(location));

테이블 목록 조회

SELECT RELNAME AS TABLE_NAME
  FROM PG_STAT_USER_TABLES

컬럼 목록 조회

SELECT *
🌞 Morning 194 commits █████▍░░░░░░░░░░░░░░░ 25.9%
🌆 Daytime 351 commits █████████▊░░░░░░░░░░░ 46.9%
🌃 Evening 44 commits █▏░░░░░░░░░░░░░░░░░░░ 5.9%
🌙 Night 160 commits ████▍░░░░░░░░░░░░░░░░ 21.4%
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>JS Bin</title>
</head>
<body>
<script id="jsbin-javascript">