PostGreSQL questions

[rdonnay]

I tried working with PostGreSQL a few years ago and found that the ISAM simulation via PGDBE was just not ready to advise my customers that they should use it instead of ADS.

Steffen Pirsig and I had a conversation a few days ago and he convinced me that I should give it another try, especially now that ADS is only in maintenance mode and it is getting more and more difficult to communicate with SAP.

So I installed PostGreSQL 8.3.7 on my Windows 10 workstation. This is the installation provided by Alaska Software on their website. I noticed that the pgAdmin III that came with the installation (1.8.4) does not look at all like the screens shown in the Alaska documentation. It appears to be much older.

Can I ask anyone who is using PostGreSQL, which version of pgAdmin are you using?

[Auge_Ohr]

Steffen Pirsig and I had a conversation a few days ago and he convinced me that I should give it another try, especially now that ADS is only in maintenance mode and it is getting more and more difficult to communicate with SAP.

and what about communicate with Alaska ...
what does communication have to do with (bad) Performance of PgDBE ?

is any Guy of Alaska a PostgreSQL "Expert"
try to ask in SQL Forum about Concept of "ISAM Emulation" ...
they just will answer "who was the BEGINNER" who made the Concept

Can I ask anyone who is using PostGreSQL, which version of pgAdmin are you using?

PostgreSQL 10.1 "native" (Phil Ide 2003)

[rdonnay]

and what about communicate with Alaska?

That has always been my biggest complaint about Alaska.
Their support forum, especially. It doesn't exist.

The only reason I'm looking into PostGreSQL now is because I am being pulled in that direction from customers.
This is the last thing I want to be doing, but maybe I can be of some help.

[PedroAlex]

I tried working with PostGreSQL a few years ago and found that the ISAM simulation via PGDBE was just not ready to advise my customers that they should use it instead of ADS.

Steffen Pirsig and I had a conversation a few days ago and he convinced me that I should give it another try, especially now that ADS is only in maintenance mode and it is getting more and more difficult to communicate with SAP.

So I installed PostGreSQL 8.3.7 on my Windows 10 workstation. This is the installation provided by Alaska Software on their website. I noticed that the pgAdmin III that came with the installation (1.8.4) does not look at all like the screens shown in the Alaska documentation. It appears to be much older.

Can I ask anyone who is using PostGreSQL, which version of pgAdmin are you using?

Hello!

I have some stuffs in remote mode
PostgreSQL 9.5 and pgAdmin III or pgAdmin 4 v2.
I have PostGre DB installed on a Win SVR2012 and my app acess data remotely.
I have workstations runing on Win7 and Win10
I works fine for me.

[rdonnay]

I have workstations runing on Win7 and Win10
I works fine for me.

Are you using PGDBE or ODBCDBE (or maybe SQLexpress) ?

Are you working in ISAM mode or all SQL statements?

[patito]

Hi Roger

The easiest way is to use the api postgresql
Native mode is much faster and easier to implement
Attached example using express , and wrapper ot4xb the Pablo


Best regard
Hector Pezoa

[rdonnay]

Ok, I see what you are doing here.

This is a bit like SQLexpress.
It does not use Workareas.

I agree that this is a faster method but I'm trying to help customers with a PostGreSQL migration strategy for large applications.

[rdonnay]

The easiest way is to use the api postgresql

I promised Steffen that I would work with the PGDBE. I intend to write a generic client program that allows me to connect to any database and execute SQL statements.

I'm trying to just get a list of databases. This works in pgAdmin but I don't know how to make it work in Xbase++:

select datname from pg_database where datistemplate = false

[Auge_Ohr]

try

Code: Select all

         ::cQuery := "SELECT table_name FROM information_schema.tables " + ;
                     "WHERE table_schema = 'public'"

.or.

Code: Select all

::oR_Table := oPG:Select( "pg_tables",, "schemaname = 'public'" )
METHOD PGSql:Select( cTable, cField, cWhere, cOrder, cLimit, cOffset )

[rdonnay]

This doesn't even compile:

Code: Select all

SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'

Cannot match to any predicted input, near <les> in table definition of FROM clause

My question is how to do this with PGDBE and the SELECT command.
You have apparently created a different interface to PostGreSQL.