DbVisualizer :: ERD diagram

Published by onesixx on

ERD for Postgresql

https://www.dbvis.com/

To see how a table is related to other tables through Foreign Keys:

  1. 왼쪽  Databases tab 에서 Tree상에  TABLE object를 선택한다. 
  2. 오른쪽 Object View tab>references sub tab,을 보면 ERD가 보인다. 

 

Categories: Postgresql

onesixx

Blog Owner

Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments

Related Posts

Postgresql

PostgreSQL Array

http://www.postgresqltutorial.com/postgresql-arrayhttps://www.timescale.com Timeserise database kj

Postgresql

regex in sql

  filename이라는 컬럼에서 날짜형식이 일치(포함)하는 행의 날짜별 row수 구하기 SELECT REGEXP_MATCHES(filename, '[0-9]{4}-[0-9]{2}-[0-9]{2}'), count(*) FROM TEST_Table GROUP BY 1 filename이라는 컬럼에서 날짜만 뽑아서 비교 select * from TEST_Table where SUBSTRING(filename, '\d{4}-\d{2}-\d{2}') = '2017-08-19'     http://www.postgresqltutorial.com/postgresql-regexp_matches/ Read more…

Postgresql

List all databases and tables

  databases SELECT datname FROM pg_database WHERE datistemplate = false;     tables SELECT table_name FROM information_schema.tables where table_catalog='tablespace' and table_schema='public' and table_type='BASE TABLE' ORDER BY 1;    

0
Would love your thoughts, please comment.x
()
x