There are many cases where we want to connect EMDI’s DB with some other program, but the fields don’t mach. In this case we can create appropriate views in SQL.
An example in changing fields in “apouhkh”.
|
1 2 3 |
CREATE OR ALTER VIEW "ITEMS" as select "apouhkh"."Aa" as ID, "apouhkh"."Perigrafh" as DESCR from "apouhkh" |
Now we can read data by using the new table.
|
1 |
select * from "ITEMS" |
Or update them.
|
1 2 |
update "ITEMS" set DESCR='test' where AA=1 |
