๐Ÿ““
Booil Jung
search
โŒ˜Ctrlk
๐Ÿ““
Booil Jung
  • MkDocs
  • docs
    • ๋ชฉ์ฐจ
    • ์†Œํ”„ํŠธ์›จ์–ด ์œตํ•ฉ
    • ์ž์œจ ์ฃผํ–‰ (Autonomous Driving/Flight)
    • _control_engineering
    • _organization
    • ์†Œํ”„ํŠธ์›จ์–ด ํ™œ์šฉ ์‚ฌ๋ก€ (Software Use Cases)
    • _study
    • agricultural_science
    • applied_math
    • artificial_intelligent
    • connections
    • ์ฝฉํŠธ
    • control_engineering
    • dbms
      • ๋ฐ์ดํ„ฐ ๊ด€๋ฆฌ ๋ฐ ๋ถ„์„ ํ”Œ๋žซํผ
      • postgresql
        • ์„œ๋ฌธ
        • chapter_01
        • chapter_02
        • chapter_03
        • chapter_04
        • chapter_05
        • chapter_06
        • chapter_07
        • chapter_08
        • chapter_09
        • chapter_10
        • chapter_11
        • chapter_12
        • chapter_13
        • chapter_14
        • chapter_15
        • chapter_16
          • JSON/JSONB ๊ณ ๊ธ‰ ํ™œ์šฉ
          • JSON ํ•จ์ˆ˜๋ฅผ ์ด์šฉํ•œ ๋ฐ์ดํ„ฐ ์ฒ˜๋ฆฌ
          • XML ํƒ€์ž…๊ณผ XPath ํ•จ์ˆ˜
          • Full-Text Search ๊ฐœ๋…(TSVECTOR, TSQUERY)
          • ํ† ํฐํ™”์™€ ์–ธ์–ด ์‚ฌ์ „ ์„ค์ •
          • GIN/GiST ์ธ๋ฑ์Šค๋ฅผ ์ด์šฉํ•œ Full-Text Search
          • JSON ๊ฒ€์ƒ‰๊ณผ Full-Text Search ๊ฒฐํ•ฉ
          • ํ•จ์ˆ˜ ๊ธฐ๋ฐ˜ ๊ฒ€์ƒ‰๊ณผ ๋žญํ‚น
          • ํ•˜์ด๋ธŒ๋ฆฌ๋“œ ๋ฌธ์„œ/๊ด€๊ณ„ํ˜• ๊ฒ€์ƒ‰ ์ „๋žต
          • PostgreSQL 16์—์„œ์˜ JSON ๊ด€๋ จ ๊ฐœ์„ ์ 
        • chapter_17
        • chapter_18
        • chapter_19
        • chapter_20
    • geospatial_science
    • hardware
    • infosec
    • interest
    • linux
    • math
    • mechanics
    • physics
    • programming
    • robot
    • sensor_data_processing
    • _9990 ๊ธฐํƒ€
    • articles
    • server_archiecture
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. docschevron-right
  2. dbmschevron-right
  3. postgresql

chapter_16

JSON/JSONB ๊ณ ๊ธ‰ ํ™œ์šฉchevron-rightJSON ํ•จ์ˆ˜๋ฅผ ์ด์šฉํ•œ ๋ฐ์ดํ„ฐ ์ฒ˜๋ฆฌchevron-rightXML ํƒ€์ž…๊ณผ XPath ํ•จ์ˆ˜chevron-rightFull-Text Search ๊ฐœ๋…(TSVECTOR, TSQUERY)chevron-rightํ† ํฐํ™”์™€ ์–ธ์–ด ์‚ฌ์ „ ์„ค์ •chevron-rightGIN/GiST ์ธ๋ฑ์Šค๋ฅผ ์ด์šฉํ•œ Full-Text Searchchevron-rightJSON ๊ฒ€์ƒ‰๊ณผ Full-Text Search ๊ฒฐํ•ฉchevron-rightํ•จ์ˆ˜ ๊ธฐ๋ฐ˜ ๊ฒ€์ƒ‰๊ณผ ๋žญํ‚นchevron-rightํ•˜์ด๋ธŒ๋ฆฌ๋“œ ๋ฌธ์„œ/๊ด€๊ณ„ํ˜• ๊ฒ€์ƒ‰ ์ „๋žตchevron-rightPostgreSQL 16์—์„œ์˜ JSON ๊ด€๋ จ ๊ฐœ์„ ์ chevron-right
Previous์ปค์Šคํ…€ ํ™•์žฅ ๊ฐœ๋ฐœ ๊ฐœ์š”chevron-leftNextJSON/JSONB ๊ณ ๊ธ‰ ํ™œ์šฉchevron-right

Last updated 1 year ago