![Logical data model](https://www.datensen.com/blog/wp-content/uploads/logical-data-model.jpg)
Tag: postgresql
Articles related to ER diagram creation in Luna Modeler – a data modeling tool for PostgreSQL and other relational databases.
![Logical data model](https://www.datensen.com/blog/wp-content/uploads/logical-data-model.jpg)
![Code defined for other database object in ER diagram for PostgreSQL.](https://www.datensen.com/blog/wp-content/uploads/postgresql-function.png)
Other database objects in PostgreSQL
![PostgreSQL Composite Properties](https://www.datensen.com/blog/wp-content/uploads/postgresql-composite-properties.png)
Composite types & PostgreSQL ER Diagram
![SQL script with CREATE TABLE statement for PostgreSQL](https://www.datensen.com/blog/wp-content/uploads/sql-create-table-statement-postgresql.webp)
How to use the CREATE TABLE statement in PostgreSQL to create a new table
![Luna Modeler - Advanced copy and paste](https://www.datensen.com/blog/wp-content/uploads/luna-modeler-copy-table.png)
Advanced Copy and Paste in Luna Modeler
![SQLite comparison](https://www.datensen.com/blog/wp-content/uploads/sqlite-comparison.png)
Updating SQLite projects
![How to update a database model for PostgreSQL](https://www.datensen.com/blog/wp-content/uploads/update-database-model-postgresql.jpg)
Updating PostgreSQL projects
![Heroku PostgreSQL ERD made with Luna Modeler](https://www.datensen.com/blog/wp-content/uploads/pg-heroku-1-1.png)
Heroku Postgres and ER diagrams
![](https://www.datensen.com/blog/wp-content/uploads/connections-list-pg-1.png)
Visualization of existing PostgreSQL databases
![Generated SQL script for PostgreSQL. Luna Modeler.](https://www.datensen.com/blog/wp-content/uploads/generating-sql-postgresql.webp)
Generating SQL script for PostgreSQL
![PostgreSQL domains](https://www.datensen.com/blog/wp-content/uploads/2021/09/postgresql-domain-selection.png)
Domains in PostgreSQL projects
![PostgreSQL Enum](https://www.datensen.com/blog/wp-content/uploads/postgresql-enum-default-value.png)
Enumerated type – Enum – PostgreSQL
![PostgreSQL ERD diagram](https://www.datensen.com/blog/wp-content/uploads/postgresql-diagram.jpg)
PostgreSQL ER diagram – graphics
![ER diagram for PostgreSQL made in Luna Modeler - database modeling tool for PostgreSQL](https://www.datensen.com/blog/wp-content/uploads/erd-postgres-database-modeling-tool-luna-modeler.webp)
PostgreSQL database design
![PostgreSQL vs MongoDB](https://www.datensen.com/blog/wp-content/uploads/postgresql-vs-mongodb.png)
MongoDB vs PostgreSQL
![Primary key - ID](https://www.datensen.com/blog/wp-content/uploads/2021/02/primary-key-id.png)
Primary key vs unique key
![Primary key - driving license](https://www.datensen.com/blog/wp-content/uploads/2021/02/primary-key-driving-license.png)