Ask Your Question
0

Insert in a PostgreSQL table from LO Base Firebird embedded table

asked 2019-07-08 09:57:43 +0100

lonk gravatar image

updated 2019-07-08 10:28:19 +0100

Both tables have the exact database field structure and PostgreSQL is on the server, is it possible to insert new records in a PostgreSQL table from 'LO Base Firebird embedded' table ?

PostgreSQL comes by default on Fedora 30 server. I don't need to additionally install Firebird database on the server. And LO Base is on Fedora 30 workstation.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-07-08 20:26:55 +0100

Ratslinger gravatar image

updated 2019-07-08 21:07:32 +0100

Hello,

First, it matters not that the two have an identical structure. There is no passing records between the two.

The answer previously given regarding Calc to Base also applies here for the most part. In your question here you are now dealing with Base as the originator. So now you must extract the data from whatever the source and using that data, then create an SQL statement to update the table for PostgreSQL.

A difference here, especially since this is a remote connection, is the actual code to connect to a remote database. The actual URL will be key in the connection. This code can be seen in my answer in this post -> Connect to mssql (ODBC) database via Macro. You can find more details in the document the referred to code was derived from - "Andrew Base" by Andrew Pitonyak found here -> Database.

Edit:

Found another of my answers which may help with the URL -> Can't remove password from LO Base connected to MySQL. My answer deals with the connection (to MySQL but others will work) and further info on URL string in comments.

edit flag offensive delete link more

Comments

@Ratslinger >>> Thank you so much for your explanation.

lonk gravatar imagelonk ( 2019-07-09 02:03:22 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-08 09:57:43 +0100

Seen: 51 times

Last updated: Jul 08