SQWareProduction:postgres:lib:sqwpg GatherStructure.lib: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| Line 7: | Line 7: | ||
gfsqw_GenListDatabase > $gvsqw_TmpFile.lst | gfsqw_GenListDatabase > $gvsqw_TmpFile.lst | ||
gfsqw_InsertIndicators "columns informations" | gfsqw_InsertIndicators "columns informations" | ||
gfsqw_InsertIndicators "indexes '%ccnew%' or '%ccold%'" | |||
gfsqw_InsertIndicators "indexes informations" | gfsqw_InsertIndicators "indexes informations" | ||
gfsqw_InsertIndicators "tables informations" | gfsqw_InsertIndicators "tables informations" | ||
| Line 14: | Line 15: | ||
lfsqw_InsertColumnsDifferences | lfsqw_InsertColumnsDifferences | ||
lfsqw_InsertIndexesDifferences | lfsqw_InsertIndexesDifferences | ||
lfsqw_InsertIndexesTemp | |||
lfsqw_InsertIndexesTemp => | |||
lfsqw_InsertStructureOk "columns" | lfsqw_InsertStructureOk "columns" | ||
lfsqw_InsertStructureOk "indexes" | lfsqw_InsertStructureOk "indexes" | ||
Latest revision as of 10:38, 11 February 2023
shell functions library $gvsqw_PgBin/../lib/sqwpg_GatherStructure.lib:
lib for sqwpg_GatherStructure.ksh
Functions explanation:
gfsqw_BeginningCom gfsqw_GenListDatabase > $gvsqw_TmpFile.lst gfsqw_InsertIndicators "columns informations" gfsqw_InsertIndicators "indexes '%ccnew%' or '%ccold%'" gfsqw_InsertIndicators "indexes informations" gfsqw_InsertIndicators "tables informations" lfsqw_Columns => lfsqw_GatherTables => lfsqw_Indexes => lfsqw_InsertColumnsDifferences lfsqw_InsertIndexesDifferences lfsqw_InsertIndexesTemp lfsqw_InsertIndexesTemp => lfsqw_InsertStructureOk "columns" lfsqw_InsertStructureOk "indexes" lfsqw_InsertStructureOk "tables" lfsqw_InsertTablesDifferences lfsqw_PrepareColumnsDifferences lfsqw_PrepareIndexesDifferences lfsqw_PrepareTablesDifferences lfsqw_Tables =>
