Re: SQL tab - DDL syntax
| От | Ashesh Vashi |
|---|---|
| Тема | Re: SQL tab - DDL syntax |
| Дата | |
| Msg-id | CAG7mmoxbduWGC9zdQ+bsNxVjU4QVk94XTUDB_pj15V7=8VNELg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: SQL tab - DDL syntax (matshyeq <matshyeq@gmail.com>) |
| Ответы |
Re: SQL tab - DDL syntax
(Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
|
| Список | 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 по дате отправления: