Re: SQL tab - DDL syntax - Mailing list pgadmin-support
| From | Ashesh Vashi |
|---|---|
| Subject | Re: SQL tab - DDL syntax |
| Date | |
| Msg-id | CAG7mmoxbduWGC9zdQ+bsNxVjU4QVk94XTUDB_pj15V7=8VNELg@mail.gmail.com Whole thread Raw |
| In response to | Re: SQL tab - DDL syntax (matshyeq <matshyeq@gmail.com>) |
| Responses |
Re: SQL tab - DDL syntax
|
| List | pgadmin-support |
On Thu, Mar 30, 2017 at 1:05 PM, matshyeq <matshyeq@gmail.com> wrote:
when pressing 'Send' I felt this is the answer I'm going to get…fair enoughBefore I try to find the right place and figure it out - could you answer that question:
We reverse engineer the SQL based on the existing data in the datable.
Each node has its own logic for reverse engineering.
Output of the reversed engineering SQL can be combination of multiple Jinja2 templates.
For the database - we have logic in the 'web/pgadmin/browser/server_groups/servers/databases', we uses different Jinja2 templates.
Similarly - we have reverse engineering templates for each database objects.
You can find them under the database directories, and they maintain their hierarchical position in it.
Hope - this will help you to figure out, what you're looking for.
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA
>> is the logic to get what's displayed in the SQL tab custom programmed in pgAdmin or leverages some some built-in postgres DB functionality and only presents same output back?Thank you,Kind Regards~MaciekOn 30 March 2017 at 07:31, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote: pgAdmin4 is open source so there is nothing to disclose :)you can refer the source code https://www.pgadmin.org/development/git.php --Regards,On Wed, Mar 29, 2017 at 6:21 PM, matshyeq <matshyeq@gmail.com> wrote:Hello,I need to automate comparison of schemas between DBs.I've found that pg_dump produces different order of tables etc.. so can't directly compare thatbut on the other hand I see pgAdmin brings up really neat syntax (and different from pg_dump)Could you guys disclose if the logic to get SQL for a table is custom programmed by pgAdmin or uses some some built-in postgres DB functionality and only displays it's output back?Thank you,Kind Regards~Maciek
pgadmin-support by date: