PostGIS Core Support Unlock powerful mapping features with PostGIS Core Support in Luna Modeler and enhance your diagrams with specific data types. Primary Key vs Unique Key What's the difference between primary keys and unique keys? Learn how to define a unique key, how to use the key for relationships and more. Visualization of existing PostgreSQL databases Connect to a PostgreSQL database and reverse engineer your existing database structures. Visualize databases and create ER diagrams. PostgreSQL database design Luna Modeler for PostgreSQL database design. See how to visually create ER diagrams for PostgreSQL and generate SQL Scripts PostgreSQL ER diagram - graphics Use Luna Modeler and visualize PostgreSQL tables, composite types and other objects in a PostgreSQL ER diagram. Enumerated type - Enum - PostgreSQL How to define enumerated types (enum) for PostgreSQL in Luna Modeler - ER diagram tool for PostgreSQL and other databases. Domains in PostgreSQL projects Read how to specify PostgreSQL domains in Luna Modeler, a database modeling tool for PostgreSQL and other databases. Generating SQL scripts for PostgreSQL Read how to easily generate SQL script for PostgreSQL in Luna Modeler. Draw ERD and generate SQL for PostgreSQL database designs. Updating PostgreSQL projects Read how to create a new database connection and update your existing PostgreSQL ER Diagram created in Luna Modeler - a database design tool. Updating SQLite projects Read how update your existing SQLite entity relationship diagram created in Luna Modeler - a database modeling tool for relational databases. Advanced Copy and Paste in Luna Modeler See how to copy and paste one or more tables or individual columns in your ERD. Find out how to work with dependencies in Luna Modeler. Composite types & PostgreSQL ER Diagram Learn how to define composite types for PostgreSQL in Luna Modeler - ER diagram tool for PostgreSQL and other databases. Other database objects in PostgreSQL Learn how to define other database objects like functions, triggers, views and other PostgreSQL-specific objects in Luna Modeler. Logical data model Learn how to use Luna Modeler for logical data model. See how to visually create ER diagrams and convert them to selected target platform. MongoDB vs PostgreSQL Read about MongoDB vs PostgreSQL. Review differences in Luna Modeler and Moon Modeler - data modeling tools for various database platforms. Primary Key vs Foreign Key What's the difference between primary keys and foreign keys? Learn how to define a primary key, a foreign key, and how to visualize JSON.
