Stack Overflow
Stack Overflow

Questions tagged [pgmodeler]

From the project's overview page:

The name pgModeler is an acronym of PostgreSQL Database Modeler and refers to an open source database modeling tool specially designed for PostgreSQL Relational Database Management System. This software reunites the concepts of entity­-relationship diagrams and the features that PostgreSQL implements including its extensions of the SQL standards.

The tool is full featured and permits user to quickly create reliable database models and export them into several modes, from PNG image to SQL scripts as well directly to a running server. The overall features available does not stands only on modeling and exporting. Having a huge set of features this software is capable of reverse engineering existing databases producing their conceptual representation, it also compares models and databases generating SQL scripts that can be used to synchronize the database to the most recent model version.

From pgModeler's GitHub repository:

No more DDL commands written by hand let pgModeler do the job for you!

10 questions
8
votes
3 answers

Postgres "CREATE TABLE AS (SELECT ...)" stuck

I am using Python with psycopg2 2.8.6 against Postgresql 11.6 (also tried on 11.9) When I am running a query CREATE TABLE tbl AS (SELECT (row_number() over())::integer "id", "col" FROM tbl2) Code is getting stuck (cursor.execute never returns),…
Meir Tseitlin
  • 1,878
  • 2
  • 17
  • 28
4
votes
2 answers

Cannot install pgmodeler

I got problem while compiling pgmodeler on Mac. I typed qmake pgmodeler.pro in binary folder, and got the following error: /Users/****/Applications/pgmodelerunzip/pgmodeler-0.8.1-beta/pgmodeler.pri:21: defined(function, type): unexpected type…
vicugna
  • 43
  • 1
  • 5
2
votes
1 answer

exclude constraints in pgmodeler

I want to add an exclusion constraint to a table in pgmodeler. Example table: create table x ( lable varchar(2) not null, timerange tstzrange not null, primary key (lable, timerange)) ); And I want to add: alter table x add constraint…
paul
  • 408
  • 2
  • 8
1
vote
0 answers

pgModeler can't see DB structure

I have 2 PostgreSQL DBs on my server. I've made all settings and can see both DBs in pgModeler, but it can't see non schemas non tables of one of these DBs. I've already checked for permissions in DB settings, but they are totally the same for both…
Dmitry
  • 361
  • 6
  • 21
1
vote
1 answer

How to distinguish per-user vs. system-wide installation in QT installer framework?

I'm using some app called pgModeler and it's current version provides an installer based on QT installer framework. The problem with that installer on Windows is that it installs start menu entries per-user only and registers the app itself per-user…
Thorsten Schöning
  • 3,501
  • 2
  • 25
  • 46
1
vote
1 answer

Is pgmodeler only used for PostgreSQL?

pgmodeler is said to be PostgreSQL Database Modeler. As far as I know it is for relational database design, and relational database design isn't RDMBS specific. So is pgmodeler only used for PostgreSQL? Can it be used with other RDBMS, such as…
user10082400
0
votes
0 answers

PgModeler : better description in the html file

Context: I'm using pgmodeler to propose data model/data dictionary for a project. I have a lot of fields who need a description (list form like that: if this: ex 1 ex 2 ex 3 ... if that: ex 4 ex 5 ) In the program it show in this format. But…
Decoster Corentin
  • 1
  • 1
0
votes
1 answer

Why do we need to resolve dependencies after `make` and `make install`?

https://pgmodeler.io/support/installation says: Resolving dependencies After successfully compile the source code and install the binaries we need to copy some dependencies into the pgModeler's installation folder as well run some commands in order…
user10082400
0
votes
1 answer

Opening a dbm file

I have been provided a file, called datamodel.dbm Within that file, is a lot of XML. It opens with the following XML: