{"id":25488,"date":"2025-07-07T06:15:24","date_gmt":"2025-07-07T03:15:24","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/"},"modified":"2025-07-07T06:15:24","modified_gmt":"2025-07-07T03:15:24","slug":"postgresql-tablodan-birden-cok-satir-nasil-silinir","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/","title":{"rendered":"PostgreSQL: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir"},"content":{"rendered":"<p># PostgreSQL&#8217;de \u00c7oklu Sat\u0131r Silme: Tam Bir Rehber<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda y\u00fczlerce, binlerce hatta milyonlarca sat\u0131r\u0131n\u0131z oldu\u011funu ve bunlardan belirli bir kritere uyanlar\u0131n\u0131 silmeniz gerekti\u011fini hayal edin. Tek tek silmek hem zaman al\u0131c\u0131 hem de hata riski y\u00fcksek bir i\u015flem olurdu. \u0130\u015fte tam burada PostgreSQL&#8217;in g\u00fc\u00e7l\u00fc silme komutlar\u0131n\u0131 kullanarak verimli ve g\u00fcvenli bir \u015fekilde \u00e7oklu sat\u0131r silmenin yollar\u0131n\u0131 \u00f6\u011frenmeniz gerekiyor. Bu rehber, yeni ba\u015flayanlardan uzmanlara kadar herkes i\u00e7in PostgreSQL&#8217;de \u00e7oklu sat\u0131r silme i\u015flemini ad\u0131m ad\u0131m a\u00e7\u0131klayacak, ger\u00e7ek d\u00fcnya \u00f6rnekleri ve performans optimizasyon teknikleri sunacakt\u0131r.<\/p>\n<p><strong>PostgreSQL&#8217;de \u00c7oklu Sat\u0131r Silme: Temel Kavramlar<\/strong><\/p>\n<p>PostgreSQL&#8217;de verileri silmek i\u00e7in temel komut <code class=\"language-\">DELETE<\/code> komutudur.  Bu komut, <code class=\"language-\">WHERE<\/code> ko\u015fulu ile birlikte kullan\u0131l\u0131r ve yaln\u0131zca belirtilen ko\u015fulu sa\u011flayan sat\u0131rlar silinir.  <code class=\"language-\">WHERE<\/code> ko\u015fulu olmadan <code class=\"language-\">DELETE<\/code> komutu kullan\u0131l\u0131rsa, tablodaki t\u00fcm sat\u0131rlar silinir. Bu nedenle, verilerinizi silmeden \u00f6nce mutlaka yedek alman\u0131z veya i\u015fleminizi test ortam\u0131nda denemek son derece \u00f6nemlidir.  Ayr\u0131ca, <code class=\"language-\">DELETE<\/code> komutu <code class=\"language-\">COMMIT<\/code> komutu ile kal\u0131c\u0131 hale gelir.  <code class=\"language-\">ROLLBACK<\/code> komutu ise son <code class=\"language-\">COMMIT<\/code> i\u015fleminden bu yana yap\u0131lan de\u011fi\u015fiklikleri geri al\u0131r. Bu iki komut, veritaban\u0131 i\u015flemlerinde hata y\u00f6netimi i\u00e7in kritik \u00f6neme sahiptir.<\/p>\n<p><strong>PostgreSQL&#8217;de \u00c7oklu Sat\u0131r Silmeyi Nas\u0131l \u00d6\u011frenebilirim? \u00d6\u011frenme Yol Haritas\u0131<\/strong><\/p>\n<p>Bu rehber, PostgreSQL&#8217;de \u00e7oklu sat\u0131r silme i\u015flemini kademeli olarak ele alarak, her seviyeden kullan\u0131c\u0131n\u0131n anlayabilece\u011fi \u015fekilde a\u00e7\u0131klamaktad\u0131r.<\/p>\n<p><strong>Yeni Ba\u015flayan:<\/strong><\/p>\n<p><strong>Ad\u0131m 1:<\/strong> Basit bir tablo olu\u015fturun.<\/p>\n<pre class=\"language-sql\"><code>CREATE TABLE urunler (\n    urun_id SERIAL PRIMARY KEY,\n    urun_adi VARCHAR(255),\n    fiyat NUMERIC(10,2)\n);<\/code><\/pre>\n<p><strong>Ad\u0131m 2:<\/strong> Tabloya baz\u0131 veriler ekleyin.<\/p>\n<pre class=\"language-sql\"><code>INSERT INTO urunler (urun_adi, fiyat) VALUES\n('Masa', 250.00),\n('Sandalye', 75.00),\n('Lamba', 50.00),\n('Masa', 300.00),\n('Sandalye', 100.00);<\/code><\/pre>\n<p><strong>Ad\u0131m 3:<\/strong>  <code class=\"language-\">WHERE<\/code> ko\u015fulu kullanarak belirli sat\u0131rlar\u0131 silin. \u00d6rne\u011fin, fiyat\u0131 75.00 olan sandalye sat\u0131r\u0131n\u0131 silmek i\u00e7in:<\/p>\n<pre class=\"language-sql\"><code>DELETE FROM urunler WHERE urun_adi = 'Sandalye' AND fiyat = 75.00;<\/code><\/pre>\n<p><strong>Ad\u0131m 4:<\/strong> De\u011fi\u015fiklikleri kal\u0131c\u0131 hale getirmek i\u00e7in <code class=\"language-\">COMMIT<\/code> komutunu \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n<pre class=\"language-sql\"><code>COMMIT;<\/code><\/pre>\n<p><strong>Orta Seviye:<\/strong><\/p>\n<p><strong>Ger\u00e7ek Hayat \u00d6rne\u011fi:<\/strong> Bir e-ticaret sitesindeki eski veya ge\u00e7ersiz \u00fcr\u00fcn kay\u0131tlar\u0131n\u0131 silme.  \u00d6rne\u011fin, son 6 ayda sat\u0131\u015f\u0131 olmayan \u00fcr\u00fcnlerin silinmesi:<\/p>\n<pre class=\"language-sql\"><code>DELETE FROM urunler \nWHERE urun_id IN (SELECT urun_id FROM satislar WHERE satis_tarihi &lt; NOW() - INTERVAL '6 months');<\/code><\/pre>\n<p>(Bu \u00f6rnekte <code class=\"language-\">satislar<\/code> tablosunun var oldu\u011funu ve <code class=\"language-\">urun_id<\/code> ve <code class=\"language-\">satis_tarihi<\/code> s\u00fctunlar\u0131n\u0131 i\u00e7erdi\u011fini varsay\u0131yoruz.)<\/p>\n<p><strong>Optimizasyon \u0130pu\u00e7lar\u0131:<\/strong>  <code class=\"language-\">WHERE<\/code> ko\u015fulunuzu m\u00fcmk\u00fcn oldu\u011funca spesifik hale getirin.  \u0130ndeks kullan\u0131m\u0131 performans\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131r\u0131r.  Silme i\u015flemi b\u00fcy\u00fck bir tabloya uygulan\u0131yorsa, i\u015flemi par\u00e7alara b\u00f6lmek (\u00f6rne\u011fin, <code class=\"language-\">OFFSET<\/code> ve <code class=\"language-\">LIMIT<\/code> kullanarak) daha az kaynak t\u00fcketimi sa\u011flar.  \u0130\u015flemden \u00f6nce <code class=\"language-\">VACUUM<\/code> komutunu \u00e7al\u0131\u015ft\u0131rmak, performans\u0131 iyile\u015ftirebilir.  <code class=\"language-\">ANALYZE<\/code> komutu, istatistikleri g\u00fcncelleyerek sorgu planlay\u0131c\u0131s\u0131n\u0131n daha iyi bir plan olu\u015fturmas\u0131na yard\u0131mc\u0131 olur.<\/p>\n<p><strong>\u0130leri Seviye:<\/strong><\/p>\n<p><strong>Performans Analizi:<\/strong>  <code class=\"language-\">EXPLAIN ANALYZE<\/code> komutu, <code class=\"language-\">DELETE<\/code> komutunun performans\u0131n\u0131 analiz etmek i\u00e7in kullan\u0131l\u0131r.  Bu, sorgu plan\u0131n\u0131 ve her ad\u0131m\u0131n s\u00fcresini g\u00f6sterir.  Bu bilgiler, sorguyu optimize etmek i\u00e7in kullan\u0131labilir.<\/p>\n<p><strong>Edge Case&#8217;ler:<\/strong>  Cascade silme (bir tablodaki bir sat\u0131r silindi\u011finde, di\u011fer tablolarla olan ili\u015fkiler nedeniyle di\u011fer tablolar\u0131ndaki ilgili sat\u0131rlar\u0131n da otomatik olarak silinmesi),  yumu\u015fak silme (sat\u0131rlar\u0131 fiziksel olarak silmek yerine, bir durum s\u00fctununu g\u00fcncelleyerek &#8220;silindi&#8221; olarak i\u015faretleme),  b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in performans optimizasyonu (par\u00e7alama, batch processing).  Bu senaryolar i\u00e7in daha karma\u015f\u0131k SQL sorgular\u0131 ve potansiyel olarak PL\/pgSQL fonksiyonlar\u0131 gerekebilir.  \u00d6rne\u011fin, b\u00fcy\u00fck bir tablodaki verileri kademeli olarak silmek i\u00e7in:<\/p>\n<pre class=\"language-sql\"><code>DO $$\nDECLARE\n  deleted_count INTEGER := 0;\n  batch_size INTEGER := 1000; -- Her seferde silinecek sat\u0131r say\u0131s\u0131\nBEGIN\n  LOOP\n    DELETE FROM urunler WHERE urun_id &gt; 10000 ORDER BY urun_id LIMIT batch_size;\n    GET DIAGNOSTICS deleted_count = ROW_COUNT;\n    IF deleted_count = 0 THEN\n      EXIT;\n    END IF;\n    RAISE NOTICE '% sat\u0131r silindi.', deleted_count;\n  END LOOP;\n  COMMIT;\nEND $$;<\/code><\/pre>\n<p>Bu kod blo\u011fu, <code class=\"language-\">urunler<\/code> tablosundan <code class=\"language-\">urun_id<\/code> 10000&#8217;den b\u00fcy\u00fck sat\u0131rlar\u0131 1000&#8217;lik par\u00e7alara b\u00f6lerek siler.  Her par\u00e7an\u0131n silinmesinden sonra ka\u00e7 sat\u0131r silindi\u011fi ekrana yazd\u0131r\u0131l\u0131r.<\/p>\n<p><strong>PostgreSQL&#8217;de \u00c7oklu Sat\u0131r Silme: Uygulamal\u0131 K\u0131lavuz<\/strong><\/p>\n<p>Yukar\u0131da verilen \u00f6rneklerin yan\u0131 s\u0131ra, \u00e7e\u015fitli ko\u015fullar alt\u0131nda \u00e7oklu sat\u0131r silme i\u015flemlerini g\u00f6steren birka\u00e7 pratik \u00f6rnek daha verelim.<\/p>\n<p><strong>\u00d6rnek 1:<\/strong>  <code class=\"language-\">urun_adi<\/code> s\u00fctununda &#8220;Masa&#8221; kelimesi ge\u00e7en t\u00fcm sat\u0131rlar\u0131 silme:<\/p>\n<pre class=\"language-sql\"><code>DELETE FROM urunler WHERE urun_adi LIKE '%Masa%';<\/code><\/pre>\n<p><strong>\u00d6rnek 2:<\/strong>  <code class=\"language-\">fiyat<\/code> s\u00fctununda 100.00&#8217;den b\u00fcy\u00fck de\u011ferlere sahip sat\u0131rlar\u0131 silme:<\/p>\n<pre class=\"language-sql\"><code>DELETE FROM urunler WHERE fiyat &gt; 100.00;<\/code><\/pre>\n<p><strong>\u00d6rnek 3:<\/strong>  <code class=\"language-\">urun_id<\/code> s\u00fctununda belirli bir listedeki ID&#8217;lere sahip sat\u0131rlar\u0131 silme:<\/p>\n<pre class=\"language-sql\"><code>DELETE FROM urunler WHERE urun_id IN (1, 3, 5);<\/code><\/pre>\n<p><strong>PostgreSQL&#8217;de \u00c7oklu Sat\u0131r Silme: Performans Optimizasyonu<\/strong><\/p>\n<p>PostgreSQL&#8217;de \u00e7oklu sat\u0131r silme i\u015flemlerinin performans\u0131n\u0131 optimize etmek i\u00e7in a\u015fa\u011f\u0131daki ipu\u00e7lar\u0131n\u0131 kullanabilirsiniz:<\/p>\n<p>* <strong>\u0130ndeksler:<\/strong>  Silme i\u015fleminde kullan\u0131lan s\u00fctunlara indeks eklemek, performans\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131rabilir.<br \/>\n* <strong>WHERE ko\u015fulu:<\/strong>  <code class=\"language-\">WHERE<\/code> ko\u015fulunu m\u00fcmk\u00fcn oldu\u011funca spesifik hale getirin.  Genel ko\u015fullar, daha fazla sat\u0131r taranmas\u0131na ve dolay\u0131s\u0131yla daha uzun i\u015flem s\u00fcrelerine neden olabilir.<br \/>\n* <strong>VACUUM ve ANALYZE:<\/strong>  <code class=\"language-\">VACUUM<\/code> komutu, silinen sat\u0131rlar\u0131n b\u0131rakt\u0131\u011f\u0131 bo\u015flu\u011fu temizlerken, <code class=\"language-\">ANALYZE<\/code> komutu istatistikleri g\u00fcnceller ve sorgu planlay\u0131c\u0131s\u0131n\u0131n daha iyi bir plan olu\u015fturmas\u0131na yard\u0131mc\u0131 olur.<br \/>\n* <strong>Batch \u0130\u015flemleri:<\/strong>  B\u00fcy\u00fck tablolar i\u00e7in, verileri par\u00e7alara b\u00f6lerek (\u00f6rne\u011fin, yukar\u0131daki \u00f6rnekte g\u00f6sterildi\u011fi gibi) silmek daha verimli olabilir.<br \/>\n* <strong>Transaction Management:<\/strong>  B\u00fcy\u00fck silme i\u015flemlerini transactionlar i\u00e7inde \u00e7al\u0131\u015ft\u0131rmak, hata durumunda geri alma i\u015flemlerini kolayla\u015ft\u0131r\u0131r.<\/p>\n<p><strong>Sonu\u00e7<\/strong><\/p>\n<p>PostgreSQL&#8217;de \u00e7oklu sat\u0131r silme i\u015flemi, <code class=\"language-\">DELETE<\/code> komutu ve <code class=\"language-\">WHERE<\/code> ko\u015fulu kullan\u0131larak ger\u00e7ekle\u015ftirilir.  Bu i\u015flem, verileri y\u00f6netmek ve veritaban\u0131n\u0131 temiz tutmak i\u00e7in hayati \u00f6nem ta\u015f\u0131r.  Ancak, verilerinizi silmeden \u00f6nce mutlaka yedek alman\u0131z ve i\u015flemi test ortam\u0131nda denemeniz \u00f6nerilir.  Bu rehberde anlat\u0131lan teknikleri ve ipu\u00e7lar\u0131n\u0131 kullanarak, PostgreSQL veritaban\u0131n\u0131zdaki \u00e7oklu sat\u0131r silme i\u015flemlerini verimli ve g\u00fcvenli bir \u015fekilde ger\u00e7ekle\u015ftirebilirsiniz.  Daha detayl\u0131 bilgi ve ileri d\u00fczey teknikler i\u00e7in [fatihsoysal.com](https:\/\/fatihsoysal.com) adresini ziyaret edebilirsiniz.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1. <strong><code class=\"language-\">DELETE<\/code> komutunu geri alabilir miyim?<\/strong> Evet, <code class=\"language-\">ROLLBACK<\/code> komutu ile son <code class=\"language-\">COMMIT<\/code> i\u015fleminden bu yana yap\u0131lan de\u011fi\u015fiklikleri geri alabilirsiniz. Ancak, <code class=\"language-\">COMMIT<\/code> komutundan sonra de\u011fi\u015fiklikler kal\u0131c\u0131 hale gelir.<\/p>\n<p>2. <strong>B\u00fcy\u00fck tablolar i\u00e7in silme i\u015flemini nas\u0131l optimize edebilirim?<\/strong>  Yukar\u0131da belirtildi\u011fi gibi, batch i\u015flemleri, indeksler ve <code class=\"language-\">VACUUM<\/code>\/<code class=\"language-\">ANALYZE<\/code> komutlar\u0131n\u0131 kullanarak performans\u0131 optimize edebilirsiniz.<\/p>\n<p>3. <strong>Cascade silme nedir?<\/strong> Cascade silme, bir tablodaki bir sat\u0131r silindi\u011finde, di\u011fer tablolarla olan ili\u015fkiler nedeniyle di\u011fer tablolar\u0131ndaki ilgili sat\u0131rlar\u0131n da otomatik olarak silinmesidir.<\/p>\n<p>4. <strong>Yumu\u015fak silme nedir?<\/strong> Yumu\u015fak silme, sat\u0131rlar\u0131 fiziksel olarak silmek yerine, bir durum s\u00fctununu g\u00fcncelleyerek &#8220;silindi&#8221; olarak i\u015faretleme i\u015flemidir.<\/p>\n<p>5. <strong><code class=\"language-\">DELETE<\/code> komutu ile <code class=\"language-\">TRUNCATE<\/code> komutu aras\u0131ndaki fark nedir?<\/strong> <code class=\"language-\">DELETE<\/code> komutu, belirli ko\u015fullara uyan sat\u0131rlar\u0131 silerken, <code class=\"language-\">TRUNCATE<\/code> komutu tablodaki t\u00fcm sat\u0131rlar\u0131 siler ve daha h\u0131zl\u0131d\u0131r, ancak geri al\u0131namaz.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de \u00c7oklu Sat\u0131r Silme: Tam Bir Rehber PostgreSQL veritaban\u0131n\u0131zda y\u00fczlerce, binlerce hatta milyonlarca sat\u0131r\u0131n\u0131z oldu\u011funu ve bunlardan&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-25488","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: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir<\/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-tablodan-birden-cok-satir-nasil-silinir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-07T03:15:24+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=\"6 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir\",\"datePublished\":\"2025-07-07T03:15:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/\"},\"wordCount\":1081,\"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-tablodan-birden-cok-satir-nasil-silinir\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/\",\"name\":\"PostgreSQL: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-07-07T03:15:24+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir\"}]},{\"@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: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir","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-tablodan-birden-cok-satir-nasil-silinir\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-07-07T03:15:24+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir","datePublished":"2025-07-07T03:15:24+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/"},"wordCount":1081,"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-tablodan-birden-cok-satir-nasil-silinir\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/","name":"PostgreSQL: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-07-07T03:15:24+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-tablodan-birden-cok-satir-nasil-silinir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: Tablodan Birden \u00c7ok Sat\u0131r Nas\u0131l Silinir"}]},{"@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\/25488","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=25488"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/25488\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=25488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=25488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=25488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}