{"action":"created","issue":{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/272","repository_url":"https://api.github.com/repos/ondras/wwwsqldesigner","labels_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/272/labels{/name}","comments_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/272/comments","events_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/272/events","html_url":"https://github.com/ondras/wwwsqldesigner/issues/272","id":365983755,"node_id":"MDU6SXNzdWUzNjU5ODM3NTU=","number":272,"title":"Reverse Enginering support For Postgres?","user":{"login":"martinmurciego","id":7759127,"node_id":"MDQ6VXNlcjc3NTkxMjc=","avatar_url":"https://avatars2.githubusercontent.com/u/7759127?v=4","gravatar_id":"","url":"https://api.github.com/users/martinmurciego","html_url":"https://github.com/martinmurciego","followers_url":"https://api.github.com/users/martinmurciego/followers","following_url":"https://api.github.com/users/martinmurciego/following{/other_user}","gists_url":"https://api.github.com/users/martinmurciego/gists{/gist_id}","starred_url":"https://api.github.com/users/martinmurciego/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martinmurciego/subscriptions","organizations_url":"https://api.github.com/users/martinmurciego/orgs","repos_url":"https://api.github.com/users/martinmurciego/repos","events_url":"https://api.github.com/users/martinmurciego/events{/privacy}","received_events_url":"https://api.github.com/users/martinmurciego/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-10-02T16:39:39Z","updated_at":"2018-10-18T21:05:19Z","closed_at":null,"author_association":"NONE","body":"Good tool. I am interested in the function of drawing the diagram doing inverse engineering of a sql script (DDL) of a postgres database."},"comment":{"url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/comments/431163010","html_url":"https://github.com/ondras/wwwsqldesigner/issues/272#issuecomment-431163010","issue_url":"https://api.github.com/repos/ondras/wwwsqldesigner/issues/272","id":431163010,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMTE2MzAxMA==","user":{"login":"martinmurciego","id":7759127,"node_id":"MDQ6VXNlcjc3NTkxMjc=","avatar_url":"https://avatars2.githubusercontent.com/u/7759127?v=4","gravatar_id":"","url":"https://api.github.com/users/martinmurciego","html_url":"https://github.com/martinmurciego","followers_url":"https://api.github.com/users/martinmurciego/followers","following_url":"https://api.github.com/users/martinmurciego/following{/other_user}","gists_url":"https://api.github.com/users/martinmurciego/gists{/gist_id}","starred_url":"https://api.github.com/users/martinmurciego/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martinmurciego/subscriptions","organizations_url":"https://api.github.com/users/martinmurciego/orgs","repos_url":"https://api.github.com/users/martinmurciego/repos","events_url":"https://api.github.com/users/martinmurciego/events{/privacy}","received_events_url":"https://api.github.com/users/martinmurciego/received_events","type":"User","site_admin":false},"created_at":"2018-10-18T21:05:19Z","updated_at":"2018-10-18T21:05:19Z","author_association":"NONE","body":"\r\nI can only tell you that the queries used are working perfectly for version 9.5 of postgres that I am using. It works to recover names of: tables, columns, PK, FK. It would be necessary to create a correspondence between Postgres data types and MySQL data types as some tools that normally distinguish a logical model from a physical model do to separate the definitions of those data types in the database engines. I would fail to try this code to see how to run it but the queries have access to the schema or catalog of the database."}}
{"actor":{"display_login":"martinmurciego"}}