Controle the order of elements in SQL export.

[vinny42]

The current version of DBSchema dumps out all the SQL in a single file and gets the order wrong for PostgreSQL;
the tables are created before the the sequences, but a table can require the existence of a sequence if it uses nextval() as a default value in a column.

Obviously dbschema cannot analyse all dependencies but I know the correct order for my database so it would be very nice if we could manually define (or at least override) the export-order.

[Martin.Sawyer]

Hello,

Your feature requested has been submitted to our software engineers.

Regards,

Martin

[stathis]

+1 vote for this feature.

I have created a schema in my development server but i cannot use the dbschema to create it in the production server, because of the order.

More specifically, trying to create a table before the creation of referenced tables. A possible solution might be the exposure of an API as pointed in another feature request, where someone could colntrol the order by Java.

[flogger123]

Add me up. This would save us so much time when this will be available.

[Martin.Sawyer]

+1 Vote for this feature has been added

[donose.mihai]

The sequence problem should be fixed. Please upgrade to the latest version.

Go to Edit -> Configuration -> Automatic Updates -> Update Source -> Beta -> Save and Close | go to Help -> Check for updates, after the updates completes, restart DbSchema.

The second reply, about the table creation order should also be fixed. DbSchema checks the table order and keeps track about foreign keys.
Can you please provide a sample project where the tables are created in the wrong order ? We couldn't reproduce the problem on our side.