==========================================================================
  PgDumpNavi  Ver 1.0.0
    PostgreSQL ̃_vt@C (pg_dump / pg_dumpall) 
    T[o[ȂŊJĒgc[
==========================================================================

        : Miyacode
  A    : goldteru2fft@gmail.com
  ҂ Web: https://pgdumpnavi.pages.dev/
        : VFAEFA (5000~AVector VFAWő)
  ΉOS    : Windows 10 / 11 (64bit)

--------------------------------------------------------------------------
 ڎ
--------------------------------------------------------------------------
   1. ͂߂
   2. 
   3. CXg[ / ACXg[
   4. g (Tv)
   5. ΉĂ_v`
   6. WHERE ̏
   7. ݒt@Cɂ
   8. iE@ƃCZX̓o^
   9. ӎ / m̐
  10. 쌠EƐӎE]ڏ

--------------------------------------------------------------------------
 1. ͂߂
--------------------------------------------------------------------------
  PgDumpNavi ́APostgreSQL  pg_dump / pg_dumpall ŏo͂
  _vt@CAPostgreSQL T[o[ɕɂ̂܂܊JāA
  e[üꗗƒg邽߂ Windows p\tgłB

  ũ_vɂǂ̕\Ă邩m肽vů
  Ȃvu̍smFvuCSV ɎovƂ
  ʂŁA_vt@ChbO&hbv邾Ŏg܂B

  ȋ@\
  Ee[üꗗ (E񐔕t) ƍsf[^̕\ (y[Wؑ)
  EWHERE  (SQL  WHERE Ɠ) ƃL[[hɂ
    s̍i荞
  E\̑IA1 s̑Scɕׂus̏ڍׁv\
  ECSV o (Ss / i荞݌ / \̃y[WAR[hE
    ؂蕶ENULL ̕\Lw\)
  EDDL (CREATE TABLEAACfbNXARgAr[A֐
    Ȃ) ̕\ERs[Eۑ
  E_ṽvpeB (`Ao[WAGR[fBOA쐬)
  Epg_dumpall ̃_v́Af[^x[X؂ւĕ\

  ݒ̓WXgg킸Ast@CƓtH_ INI t@C
  ۑ܂B

--------------------------------------------------------------------------
 2. 
--------------------------------------------------------------------------
  OS        : Windows 10 / Windows 11 (64bit )
  ^C: svłBKvȃCu͎st@CɊ܂܂
              ܂ (Visual C++ ̍ĔЕz\pbP[WȂǂʂ
              CXg[Kv͂܂)B
  ̑    : PostgreSQL ̃T[o[NCAg͕svłB
  fBXN  : e[uJƁÃe[u̍sf[^ Windows 
              ꎞtH_ (%TEMP%\PgDumpNavi) ɓWJ܂B傫
              e[uJƂ́A̋̕󂫗eʂKvłB
              ꎞt@C͏Iɍ폜܂B

--------------------------------------------------------------------------
 3. CXg[ / ACXg[
--------------------------------------------------------------------------
  yCXg[z
    _E[h zip WJÃtH_Dȏꏊɒu
    BꂾŎg܂BCXg[͂܂B

      PgDumpNavi\
        PgDumpNavi.exe      {
        PgDumpNavi.ini      ݒt@C (ݒ)
        readme.txt          ̃t@C
        manual\PgDumpNavi_}jA.pdf
                            }jA (ʕt̐)

    ݂łȂtH_ (Program Files Ȃ) ɒuƐݒ肪
    ۑłȂ߁AhLgtH_߂܂B

  yACXg[z
    {\tg̓CXg[[gȂ߁AWindows ́uݒ  Avv
    uRg[pl  vO̒ǉƍ폜v̈ꗗɂ
    \܂B̎菇ō폜ĂB

    1. PgDumpNavi I܂B
    2. PgDumpNavi.exe ĂtH_Ãt@C
       (PgDumpNavi.iniAreadme.txtAmanual tH_) ƍ폜܂B
    3. IȂǂňꎞt@CcĂꍇ́ÃtH_
       폜܂ (ʏ̏Ił͎ŏ܂)B
         %TEMP%\PgDumpNavi
       GNXv[[̃AhXɏ͂̕ Enter 
       ƊJ܂B
    4. V[gJbgĂꍇ́A폜܂B

    WXg͎gĂȂ߁AȊO̍폜Ƃ͕Kv܂B
    CZX̓o^ PgDumpNavi.ini ɂAtH_ƈꏏ
    ܂BƂŎgꍇɔāACZXL[͍T
    ĂB

--------------------------------------------------------------------------
 4. g (Tv)
--------------------------------------------------------------------------
  y_vJz
    PgDumpNavi.exe NA[J...] {^j[ [t@C] -
    [J] Ń_vt@CIт܂BEBhEɃt@C
    hbvĂJ܂BPgDumpNavi.exe ̃ACRɃhbv
    ƁANƓɊJ܂B

    Directory ` (pg_dump -Fd) ́AtH_̒ toc.dat 
    IłB

    Jƃ_vŜ𑖍āAɃe[üꗗ (E)A
    Eɐ擪̃e[u̍sf[^\܂Be[uNbN
    ƁÃe[u̍sf[^ǂݍŕ\܂B

  ysf[^̌z
    EẼObh 1 y[W 1000 s (uy[WsvŕύX) 
      \܂B̃{^ |< < > >| Ńy[Wړ܂B
    ENULL  (NULL)As܂ޒl 1 sɂ܂Ƃ߂ĕ\܂B
      l͐擪 300 ܂łłBŚus̏ڍׁvŌ܂B
    Es_uNbN (܂ Enter) Ɓus̏ڍׁvJA
      ̍s̑SuJE^Elv̌`ŏcɕ\܂B
    E[\...] ŃObhɕ\Iׂ܂B
    Ee[uꗗ̗̏ɕƁAOɂ̕܂
      e[uɈꗗi܂B

  yi荞݁z
    WHERE ɏ (6. Q)AL[[hɕ
    [i荞] (܂ Enter) ƁAvs\܂B
    L[[h͑SΏۂɂvł (啶͋
    ܂)BƁAɈvsɂȂ܂B
    [] őSs̕\ɖ߂܂B

  yCSV óz
    [CSVo...] ŁAo͔͈ (Ss / i荞݌ / ݂̃y[W)A
    ؂蕶 (J} / ^u)AR[h (UTF-8 BOM t / UTF-8 /
    Shift_JIS)Awb_s̗LApANULL ̕\Lw肵A
    ۑIԂ CSV o܂B\炵Ăꍇ́A
    ̗񂾂o͂邱Ƃł܂B

  yDDLz
    [DDL] ŁAI𒆂̃e[u CREATE TABLE ƐECfbNXE
    RgA܂̓_vŜ DDL \܂BNbv{[h
    Rs[A܂ SQL t@Cɕۑł܂B

  yvpeBz
    [t@C] - [vpeB] ŁA_v̌`Af[^x[XA
    T[o[ pg_dump ̃o[WAGR[fBOAkA
    쐬Ae[u\܂B

  ypg_dumpall ̃_vz
    ̃f[^x[X܂ރ_vł́AE DB ŕ\
    f[^x[X؂ւ܂B

--------------------------------------------------------------------------
 5. ΉĂ_v`
--------------------------------------------------------------------------
  t@C̊gqł͂ȂgŌ`𔻒肵܂B

    EPlain SQL ` (pg_dump -FpǍ`)
        COPY `̍sf[^̂قA--inserts / --column-inserts 
        o͂ INSERT ɂΉ
    EPlain SQL ` gzip k (.sql.gz)
    ECustom ` (pg_dump -Fc)Bgzip kіk
    EDirectory ` (pg_dump -Fd)BtH_ toc.dat w
    Epg_dumpall ̏o (f[^x[X)

  PostgreSQL 9.6 ` 17  pg_dump ō_vz肵Ă܂
  (J̊mF PostgreSQL 17.7 ōs܂)B

  ΏۊO: tar ` (pg_dump -Ft)Alz4 / zstd k̃_v
  (JƂɂ̎|\܂)B

  ĺA_vɏĂ镶̂܂ܕ\܂Bboolean  t / fA
  bytea  \x ɑ 16 iAz {a,b}A̓_vɋL^ꂽ
  ̂܂܂łB

--------------------------------------------------------------------------
 6. WHERE ̏
--------------------------------------------------------------------------
  SQL  WHERE Ɠ`ŏ܂ (擪 WHERE ͕sv)B

    r     =  <>  !=  <  <=  >  >=
    p^[ [NOT] LIKE  [NOT] ILIKE (啶ʂȂ)
             % ͔Cӂ̕A_ ͔Cӂ 1 A\ ŃGXP[v
    ͈͂Ȃ [NOT] BETWEEN a AND bA[NOT] IN (a, b, ...)
             IS NULLAIS NOT NULL
    _     AND  OR  NOT  ( )
    Zp     + - * / %AA ||
    ֐     UPPER LOWER LENGTH SUBSTR SUBSTRING LEFT RIGHT TRIM LTRIM
             RTRIM BTRIM STRPOS POSITION REPLACE COALESCE NULLIF
             ABS FLOOR CEIL ROUND

    : status = 'SHIPPED' AND total > 50000
        name LIKE '%c%' OR email ILIKE '%@example.com'
        order_date BETWEEN '2026-01-01' AND '2026-03-31'
        upper(code) IN ('A01', 'B02')

  ͒Ppň݂͂܂ ('  '' Ə)BJ͑啶
  ʂ܂Bl^ boolean ^̗͐lE^UlƂāA
  ȊO̗͕ƂĔr܂Bt⎞
  'YYYY-MM-DD' ̌`ŏΕrő召ł܂B
  NULL Ƃ̔r͏ɋUɂȂ̂ŁANULL TƂ IS NULL 
  gĂB

--------------------------------------------------------------------------
 7. ݒt@Cɂ
--------------------------------------------------------------------------
  st@CƓtH_ PgDumpNavi.ini ɁAy[WsA
  CSV o͂̐ݒAŌɊJtH_AEBhȆ傫A
  CZXۑ܂BIɎŕۑقA
  [t@C] - [ݒۑ] łۑł܂BeLXgGfB^
  ҏWł܂ (R[h UTF-8)B

  ϐ PGDUMPNAVI_INIFILE_PATH  INI ̃tpXݒ肷ƁA
  ̃t@Cg܂B

--------------------------------------------------------------------------
 8. iE@ƃCZX̓o^
--------------------------------------------------------------------------
  {\tg̓VFAEFAłBpɊԂ̐͂܂B

  o^̊Ԃ́Aee[u̐擪 100 sǂݍ݂܂B
  sf[^̕\Ei荞݁ECSV o͂͂ 100 sΏۂɂȂ܂B
  e[üꗗƌADDLAvpeB͐Ȃg܂B

  pĂgꍇ́AVector ̃VFAWT[rX
  Bx̊mFA҂VFAWɂo^
  [AhXփCZXL[ (PDN1-XXXX-XXXX-XXXX ̌`) 
  肵܂ ( 24 Ԉȓ)B

    i          : 5000~ (ō)
    @      : Vector VFAW
                    (Vector ̖{\tg̏Љy[W瑗ł܂B
                     x@̓VFAW̃y[WłIт܂)
    L[̑t    : VFAWɂo^̃[AhX֍҂炨肵܂
    CZX    : 1 CZXɂA{lgp PC 
                    g܂

  L[͂Aj[ [wv] - [CZXo^] JA
  OƃL[͂ [o^] ĂBL[͑啶
  nCt̗L₢܂B[wv] - [o[W] 
  uo^ς݁vƕ\ΊłBo^e PgDumpNavi.ini 
  ۑ̂ŁAʂ PC ֈڂƂ̓tH_ƃRs[邩A
  V PC œL[o^ĂB

--------------------------------------------------------------------------
 9. ӎ / m̐
--------------------------------------------------------------------------
  E_vt@CŜ̑傫 3GB ܂œmFĂ܂B
    傫_vA1 s 256MB 𒴂 Plain SQL `
    _v́Aۏ؂܂ (kɉ܂)B
  ECustom / Directory `JƂ́A𐔂邽߂
    Se[u̍sf[^WJ܂B傫ȃ_vł͊Ĵ
    Ԃ܂ (io[璆~ł܂)B
  Elz4 / zstd ňk_vAtar `̃_v͓ǂ߂܂B
    gzip kkŏo͂ĂB
  EPostgreSQL 18 ȍ~ pg_dump VA[JCu`ŏo͂
    ꍇAuΉĂȂA[JCuo[Włvƕ\܂B
  El͌^Ƃ̏ϊA_v̂̕܂܈܂B
  ECSV  Excel ŊJ܂ܓt@Cɏo͂ƁAt@C
    bNĂ邽ߎs܂BExcel Ăs
    B
  ECSV ̐擪񖼂uIDvŎn܂ꍇAExcel  SYLK `ƌF
    ̂邽߁A̗񖼂pň͂ŏo͂܂B
  Eǂ߂Ȃ_vG[΁A_v̌` (pg_dump 
    IvV)APostgreSQL ̃o[WA\ꂽbZ[W
    A܂łm点B

--------------------------------------------------------------------------
 10. 쌠EƐӎE]ڏ
--------------------------------------------------------------------------
  {\tg̒쌠 Miyacode ۗL܂B

  {\tggpƂɂĐȂ鑹QɂĂA
  ҂͐ӔC𕉂܂Bg̐ӔCłgB

  ]ځEĔzźAzzt@Cꎮς̂܂܂̌`
  sĂ莩RłBGEЁEWeb TCgւ̎^
  ۂ́Aō\܂̂ŏLA܂łm点B

  {\tg͈kf[^̓WJ miniz (Rich Geldreich قA
  pubNhC / Unlicense) gpĂ܂B

  PostgreSQL  PostgreSQL Community Association of Canada 
  WłBWindowsAExcel  Microsoft Corporation ̓o^WłB

==========================================================================
