Kjell,
In our shop we are using Firebird 2.5x for Data warehouse and Postgresql 10..x
for other projects.
Below is my list of Pros and Cons between the two. The list below is my
experience with the two products.
PostgreSQL over Firebird 2.5
Pros
* Table Partitions are
Currently we have several FIREBIRD Databases on premise. We are now looking to
replicate one of our on premise Firebird environments to AWS.
On Premise we are running Firebird 2.5.4 Classic on Linux CENTOS
CPU – 64 cores
Memory – 256GB
Disk – 9TB Raid 10 array.
We typically have around
Daniel,
Not sure if this answers your question but I've had situations where I
needed a way to get column details and table ddl within our application. We
ended up creating a stored procedure that would return that information.
The following linked helped me with understanding what needed
Kjell,
There is a product called IBEXPERT. This product is an IDE but also has a set
of command line utilities that allow you to perform scripting from a windows
CMD shell. It is very powerful. It has functions for working with files, ftp
servers, sending emails, etc.
Here is the link to