{"id":26490,"date":"2025-07-26T03:15:26","date_gmt":"2025-07-26T00:15:26","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/"},"modified":"2025-07-26T03:15:26","modified_gmt":"2025-07-26T00:15:26","slug":"postgresql-her-sutunun-varsayilan-degerlerini-alma","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/","title":{"rendered":"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma"},"content":{"rendered":"<p># PostgreSQL&#8217;de S\u00fctunlar\u0131n Varsay\u0131lan De\u011ferlerini Nas\u0131l Getiririz?<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda yeni bir sat\u0131r ekledi\u011finizde, baz\u0131 s\u00fctunlar i\u00e7in de\u011fer belirtmezseniz ne olur?  \u0130\u015fte tam da bu noktada varsay\u0131lan de\u011ferler devreye giriyor.  Bu makale, PostgreSQL&#8217;de her s\u00fctunun varsay\u0131lan de\u011ferini nas\u0131l etkili ve verimli bir \u015fekilde alabilece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacak.  Varsay\u0131lan de\u011ferleri anlamak, veritaban\u0131 tasar\u0131m\u0131n\u0131z\u0131 optimize etmek ve olas\u0131 hatalar\u0131 \u00f6nlemek i\u00e7in kritik \u00f6neme sahiptir.  Bu rehber, yeni ba\u015flayanlardan ileri seviye kullan\u0131c\u0131lara kadar herkes i\u00e7in faydal\u0131 bilgiler sunmaktad\u0131r.<\/p>\n<p><strong>PostgreSQL&#8217;de Varsay\u0131lan De\u011fer Kavram\u0131 Nedir?<\/strong><\/p>\n<p>PostgreSQL&#8217;de bir s\u00fctuna varsay\u0131lan bir de\u011fer atamak, o s\u00fctun i\u00e7in bir de\u011fer girilmedi\u011finde otomatik olarak kullan\u0131lacak bir de\u011fer belirtmek anlam\u0131na gelir. Bu, veritaban\u0131n\u0131za yeni sat\u0131rlar eklerken veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak ve gereksiz NULL de\u011ferlerini \u00f6nlemek i\u00e7in \u00e7ok faydal\u0131d\u0131r.  Varsay\u0131lan de\u011ferler, <code class=\"language-\">CREATE TABLE<\/code> komutu s\u0131ras\u0131nda veya daha sonra <code class=\"language-\">ALTER TABLE<\/code> komutu ile tan\u0131mlan\u0131r.  \u00d6rne\u011fin, bir &#8220;olusturma_tarihi&#8221; s\u00fctunu i\u00e7in varsay\u0131lan de\u011fer olarak <code class=\"language-\">CURRENT_TIMESTAMP<\/code> fonksiyonunu kullanarak, her yeni sat\u0131r\u0131n olu\u015fturuldu\u011fu zaman\u0131 otomatik olarak kaydedebiliriz.  Bu, veri giri\u015fini basitle\u015ftirir ve tutarl\u0131l\u0131\u011f\u0131 sa\u011flar.  Ancak, baz\u0131 durumlarda bu varsay\u0131lan de\u011ferleri sorgulamak ve y\u00f6netmek gerekebilir.  Bu makale, bu ihtiyac\u0131 kar\u015f\u0131lamak i\u00e7in \u00e7e\u015fitli y\u00f6ntemler sunacakt\u0131r.<\/p>\n<p><strong>PostgreSQL&#8217;de Varsay\u0131lan De\u011ferleri Sorgulaman\u0131n Temel Y\u00f6ntemleri<\/strong><\/p>\n<p>PostgreSQL&#8217;de bir tablodaki s\u00fctunlar\u0131n varsay\u0131lan de\u011ferlerini sorgulaman\u0131n en basit yolu, <code class=\"language-\">pg_attribute<\/code> sistem katalo\u011funa sorgu yapmakt\u0131r.  Bu sistem katalo\u011fu, veritaban\u0131n\u0131zdaki t\u00fcm tablolar\u0131n ve s\u00fctunlar\u0131n meta verilerini i\u00e7erir.<\/p>\n<p><strong>Yeni Ba\u015flayanlar i\u00e7in Ad\u0131m Ad\u0131m A\u00e7\u0131klama:<\/strong><\/p>\n<p>1.  <strong>Ba\u011flant\u0131 Kurma:<\/strong> PostgreSQL veritaban\u0131n\u0131za <code class=\"language-\">psql<\/code> kullanarak ba\u011flan\u0131n.<br \/>\n2.  <strong>Sorgu \u00c7al\u0131\u015ft\u0131rma:<\/strong> A\u015fa\u011f\u0131daki sorguyu \u00e7al\u0131\u015ft\u0131r\u0131n, <code class=\"language-\">'tablo_ad\u0131'<\/code> yerine sorgulamak istedi\u011finiz tablonun ad\u0131n\u0131 yaz\u0131n:<\/p>\n<pre class=\"language-sql\"><code>SELECT attname, adsrc\nFROM pg_attribute\nWHERE attrelid = 'tablo_ad\u0131'::regclass\nAND atthasdef = TRUE;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">attname<\/code> s\u00fctununda s\u00fctun ad\u0131n\u0131, <code class=\"language-\">adsrc<\/code> s\u00fctununda ise varsay\u0131lan de\u011fer tan\u0131m\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.  <code class=\"language-\">atthasdef = TRUE<\/code> ko\u015fulu, yaln\u0131zca varsay\u0131lan de\u011feri tan\u0131mlanm\u0131\u015f s\u00fctunlar\u0131 filtreler.<\/p>\n<p><strong>Basit Kod \u00d6rne\u011fi:<\/strong><\/p>\n<p>E\u011fer <code class=\"language-\">urunler<\/code> ad\u0131nda bir tablonuz varsa ve bu tablodaki s\u00fctunlar\u0131n varsay\u0131lan de\u011ferlerini \u00f6\u011frenmek istiyorsan\u0131z:<\/p>\n<pre class=\"language-sql\"><code>SELECT attname, adsrc\nFROM pg_attribute\nWHERE attrelid = 'urunler'::regclass\nAND atthasdef = TRUE;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">urunler<\/code> tablosundaki varsay\u0131lan de\u011fere sahip s\u00fctunlar\u0131n adlar\u0131n\u0131 ve varsay\u0131lan de\u011fer tan\u0131mlar\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p>\n<p><strong>Orta Seviye: Ger\u00e7ek Hayat \u00d6rne\u011fi ve Optimizasyon \u0130pu\u00e7lar\u0131<\/strong><\/p>\n<p>\u015eimdi, daha ger\u00e7ek\u00e7i bir senaryoya bakal\u0131m.  Bir e-ticaret sitesi i\u00e7in \u00fcr\u00fcn bilgilerini tutan bir veritaban\u0131n\u0131z oldu\u011funu varsayal\u0131m.  <code class=\"language-\">urunler<\/code> tablonuzda <code class=\"language-\">urun_adi<\/code>, <code class=\"language-\">fiyat<\/code>, <code class=\"language-\">stok_adedi<\/code>, <code class=\"language-\">aciklama<\/code> ve <code class=\"language-\">olusturma_tarihi<\/code> s\u00fctunlar\u0131 bulunmaktad\u0131r.  <code class=\"language-\">olusturma_tarihi<\/code> s\u00fctunu i\u00e7in varsay\u0131lan de\u011fer <code class=\"language-\">CURRENT_TIMESTAMP<\/code> olarak ayarlanm\u0131\u015ft\u0131r.  Di\u011fer s\u00fctunlar i\u00e7in ise varsay\u0131lan de\u011ferler belirlenmemi\u015ftir.<\/p>\n<p><strong>Ger\u00e7ek Hayat \u00d6rne\u011fi:<\/strong><\/p>\n<p><code class=\"language-\">urunler<\/code> tablosunun yap\u0131s\u0131n\u0131 ve varsay\u0131lan de\u011ferlerini sorgulamak i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabiliriz:<\/p>\n<pre class=\"language-sql\"><code>SELECT column_name, data_type, character_maximum_length, is_nullable, column_default\nFROM information_schema.columns\nWHERE table_name = 'urunler';<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">information_schema<\/code> i\u00e7indeki <code class=\"language-\">columns<\/code> tablosunu kullanarak tablo yap\u0131s\u0131n\u0131 ve varsay\u0131lan de\u011ferleri daha okunakl\u0131 bir \u015fekilde d\u00f6nd\u00fcr\u00fcr.  <code class=\"language-\">column_default<\/code> s\u00fctunu, varsay\u0131lan de\u011feri g\u00f6sterir.  E\u011fer bir s\u00fctun i\u00e7in varsay\u0131lan de\u011fer tan\u0131mlanmam\u0131\u015fsa, bu s\u00fctun i\u00e7in <code class=\"language-\">NULL<\/code> de\u011feri d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/p>\n<p><strong>Optimizasyon \u0130pu\u00e7lar\u0131:<\/strong><\/p>\n<p>*   Performans a\u00e7\u0131s\u0131ndan b\u00fcy\u00fck tablolar i\u00e7in bu sorguyu s\u0131k s\u0131k \u00e7al\u0131\u015ft\u0131rmaktan ka\u00e7\u0131n\u0131n.  Varsay\u0131lan de\u011ferler genellikle veritaban\u0131 tasar\u0131m a\u015famas\u0131nda belirlenir ve nadiren de\u011fi\u015ftirilir.<br \/>\n*   Gerekti\u011finde, sorguyu belirli s\u00fctunlar i\u00e7in filtreleyerek performans\u0131 art\u0131rabilirsiniz.  \u00d6rne\u011fin, sadece <code class=\"language-\">fiyat<\/code> s\u00fctununun varsay\u0131lan de\u011ferini \u00f6\u011frenmek istiyorsan\u0131z, <code class=\"language-\">WHERE column_name = 'fiyat'<\/code> ko\u015fulunu ekleyebilirsiniz.<\/p>\n<p><strong>\u0130leri D\u00fczey: Performans Analizi ve Edge Case&#8217;ler<\/strong><\/p>\n<p>Daha karma\u015f\u0131k senaryolar i\u00e7in, <code class=\"language-\">pg_description<\/code> sistem katalo\u011funu da kullanarak varsay\u0131lan de\u011ferlerin a\u00e7\u0131klamalar\u0131na eri\u015febilirsiniz.  Bu, \u00f6zellikle b\u00fcy\u00fck ve karma\u015f\u0131k veritabanlar\u0131nda varsay\u0131lan de\u011ferlerin ne ama\u00e7la kullan\u0131ld\u0131\u011f\u0131n\u0131 anlamak i\u00e7in faydal\u0131d\u0131r.<\/p>\n<p><strong>Performans Analizi:<\/strong><\/p>\n<p>Yukar\u0131da bahsedilen sorgulamalar\u0131n performans\u0131, tablonun b\u00fcy\u00fckl\u00fc\u011f\u00fcne ve veritaban\u0131 sunucusunun \u00f6zelliklerine ba\u011fl\u0131d\u0131r.  \u00c7ok b\u00fcy\u00fck tablolar i\u00e7in, bu sorgular\u0131n yan\u0131t s\u00fcresi uzun olabilir.  Bu durumda, sorguyu indeksleme veya materyalize g\u00f6r\u00fcn\u00fcmler kullanarak optimize etmek gerekebilir.  Ancak, varsay\u0131lan de\u011ferlerin sorgulanmas\u0131 genellikle nadiren yap\u0131lan bir i\u015flem oldu\u011fu i\u00e7in, performans optimizasyonu genellikle gerekli de\u011fildir.<\/p>\n<p><strong>Edge Case&#8217;ler:<\/strong><\/p>\n<p>Baz\u0131 durumlarda, varsay\u0131lan de\u011ferler karma\u015f\u0131k ifadeler veya fonksiyon \u00e7a\u011fr\u0131lar\u0131 i\u00e7erebilir.  Bu durumlarda, <code class=\"language-\">adsrc<\/code> s\u00fctununda d\u00f6nd\u00fcr\u00fclen de\u011fer, varsay\u0131lan de\u011ferin tam tan\u0131m\u0131n\u0131 yans\u0131tmayabilir.  Bu gibi durumlarda, <code class=\"language-\">CREATE TABLE<\/code> veya <code class=\"language-\">ALTER TABLE<\/code> komutlar\u0131nda kullan\u0131lan orijinal SQL ifadesine bakman\u0131z gerekebilir.<\/p>\n<p>\u00d6rne\u011fin, bir <code class=\"language-\">stok_adedi<\/code> s\u00fctunu i\u00e7in varsay\u0131lan de\u011fer olarak bir fonksiyon kullan\u0131lm\u0131\u015f olabilir:<\/p>\n<pre class=\"language-sql\"><code>ALTER TABLE urunler ALTER COLUMN stok_adedi SET DEFAULT get_default_stok_adedi();<\/code><\/pre>\n<p>Bu durumda, <code class=\"language-\">adsrc<\/code> s\u00fctunu, fonksiyonun ad\u0131n\u0131 (<code class=\"language-\">get_default_stok_adedi()<\/code>) d\u00f6nd\u00fcr\u00fcr, ancak fonksiyonun i\u00e7 i\u015fleyi\u015fini g\u00f6stermez.  Fonksiyonun nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlamak i\u00e7in fonksiyonun tan\u0131m\u0131na bakman\u0131z gerekir.<\/p>\n<p><strong>PostgreSQL&#8217;de Varsay\u0131lan De\u011ferleri G\u00fcncelleme<\/strong><\/p>\n<p>Varsay\u0131lan de\u011ferleri de\u011fi\u015ftirmek i\u00e7in <code class=\"language-\">ALTER TABLE<\/code> komutunu kullan\u0131r\u0131z.  \u00d6rne\u011fin, <code class=\"language-\">urunler<\/code> tablosundaki <code class=\"language-\">stok_adedi<\/code> s\u00fctununun varsay\u0131lan de\u011ferini 100 olarak de\u011fi\u015ftirmek i\u00e7in:<\/p>\n<pre class=\"language-sql\"><code>ALTER TABLE urunler ALTER COLUMN stok_adedi SET DEFAULT 100;<\/code><\/pre>\n<p>Varsay\u0131lan de\u011feri <code class=\"language-\">NULL<\/code> olarak ayarlamak i\u00e7in:<\/p>\n<pre class=\"language-sql\"><code>ALTER TABLE urunler ALTER COLUMN stok_adedi DROP DEFAULT;<\/code><\/pre>\n<p>Bu i\u015flemler, veritaban\u0131 tasar\u0131m\u0131n\u0131zda de\u011fi\u015fiklik yaparken dikkatlice yap\u0131lmal\u0131d\u0131r.  Varsay\u0131lan de\u011ferlerin de\u011fi\u015ftirilmesi, mevcut verileri etkileyebilir.<\/p>\n<p><strong>\u00d6zet ve S\u0131k\u00e7a Sorulan Sorular<\/strong><\/p>\n<p>Bu makale, PostgreSQL&#8217;de s\u00fctunlar\u0131n varsay\u0131lan de\u011ferlerini nas\u0131l sorgulayaca\u011f\u0131n\u0131z\u0131 ve y\u00f6netece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klad\u0131.  Yeni ba\u015flayanlardan ileri seviye kullan\u0131c\u0131lara kadar farkl\u0131 seviyelerdeki kullan\u0131c\u0131lar i\u00e7in pratik \u00f6rnekler ve ipu\u00e7lar\u0131 sunuldu.  Varsay\u0131lan de\u011ferlerin etkili kullan\u0131m\u0131, veritaban\u0131 tasar\u0131m\u0131n\u0131z\u0131 optimize etmenize ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc koruman\u0131za yard\u0131mc\u0131 olur.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1.  <strong>Varsay\u0131lan de\u011ferleri sadece belirli bir s\u00fctun i\u00e7in nas\u0131l sorgulayabilirim?<\/strong>  <code class=\"language-\">WHERE<\/code> ko\u015fulunu kullanarak <code class=\"language-\">attname<\/code> veya <code class=\"language-\">column_name<\/code> s\u00fctununu filtreleyebilirsiniz (\u00f6rne\u011fin: <code class=\"language-\">WHERE attname = 'fiyat'<\/code>).<br \/>\n2.  <strong>Varsay\u0131lan de\u011ferler, veritaban\u0131 performans\u0131n\u0131 nas\u0131l etkiler?<\/strong>  Varsay\u0131lan de\u011ferlerin kendileri performans\u0131 do\u011frudan etkilemez, ancak varsay\u0131lan de\u011ferleri sorgulamak i\u00e7in kullan\u0131lan sorgular\u0131n performans\u0131 b\u00fcy\u00fck tablolar i\u00e7in optimize edilmelidir.<br \/>\n3.  <strong>Varsay\u0131lan de\u011ferleri de\u011fi\u015ftirmenin olas\u0131 sonu\u00e7lar\u0131 nelerdir?<\/strong>  Varsay\u0131lan de\u011ferlerin de\u011fi\u015ftirilmesi, yeni eklenen sat\u0131rlarda varsay\u0131lan de\u011ferin farkl\u0131 olmas\u0131na neden olur. Mevcut veriler etkilenmez.<br \/>\n4.  <strong>Karma\u015f\u0131k varsay\u0131lan de\u011fer ifadelerini nas\u0131l y\u00f6netirim?<\/strong>  Karma\u015f\u0131k ifadeler i\u00e7in, <code class=\"language-\">adsrc<\/code> s\u00fctununda verilen bilgiyi inceleyin ve gerekti\u011finde <code class=\"language-\">CREATE TABLE<\/code> veya <code class=\"language-\">ALTER TABLE<\/code> komutlar\u0131na bak\u0131n.<br \/>\n5.  <strong>Varsay\u0131lan de\u011ferleri kullanman\u0131n avantajlar\u0131 nelerdir?<\/strong> Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flar, veri giri\u015fini basitle\u015ftirir, tutarl\u0131l\u0131\u011f\u0131 art\u0131r\u0131r ve NULL de\u011ferlerini azalt\u0131r.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de S\u00fctunlar\u0131n Varsay\u0131lan De\u011ferlerini Nas\u0131l Getiririz? PostgreSQL veritaban\u0131n\u0131zda yeni bir sat\u0131r ekledi\u011finizde, baz\u0131 s\u00fctunlar i\u00e7in de\u011fer belirtmezseniz&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[644],"tags":[],"class_list":{"0":"post-26490","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-postgresql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma<\/title>\n<meta name=\"description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-26T00:15:26+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma\",\"datePublished\":\"2025-07-26T00:15:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/\"},\"wordCount\":1200,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/\",\"name\":\"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-07-26T00:15:26+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma","description":"Hi\u00e7bir etiketi bulunamad\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-07-26T00:15:26+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma","datePublished":"2025-07-26T00:15:26+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/"},"wordCount":1200,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["PostgreSQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/","name":"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-07-26T00:15:26+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-her-sutunun-varsayilan-degerlerini-alma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: Her S\u00fctunun Varsay\u0131lan De\u011ferlerini Alma"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/26490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=26490"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/26490\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=26490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=26490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=26490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}