PostgreSQL supported?
Database ERD- design tool with Reverse Engineering
Brought to you by:
anton_nazarov
The script generated when comparing two snapshots in my PostgreSQL project is not compatible with Postgres:
alter table public.room_restrictions
modify column restriction_id integer;
alter table public.room_restrictions
modify column created_at timestamp without time zone;
alter table public.room_restrictions
modify column updated_at timestamp without time zone;
"modify" is not a Postgress verb. It should be "alter".
Also, the new data type should be preceded with "Type". Ex.:
alter table public.room_restrictions alter column created_at type timestamp without time zone;
With these issues in mind, does ApricotDB support Postgres? Or did I miss something in my setup?
Thanks.
Hi Peter,
Thank you for the info. You are right - currently Apricot only supporting the basic ANSI- based scripting (fully tested against SQLServer only).
I will have this ticket in mind for future development of the app.
regards,
Anton