{"id":30200,"date":"2025-09-24T22:40:22","date_gmt":"2025-09-24T19:40:22","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/"},"modified":"2025-09-24T22:40:22","modified_gmt":"2025-09-24T19:40:22","slug":"ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/","title":{"rendered":"Ubuntu 14.04&#8217;te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme"},"content":{"rendered":"<p># PostgreSQL Prompt&#8217;unu psqlrc ile \u00d6zelle\u015ftirme: Ubuntu 14.04 K\u0131lavuzu<\/p>\n<p>PostgreSQL ile \u00e7al\u0131\u015f\u0131rken, varsay\u0131lan komut sat\u0131r\u0131 isteminin size yetersiz geldi\u011fi anlar olabilir.  Uzun s\u00fcreli projelerde, karma\u015f\u0131k veritabanlar\u0131 \u00fczerinde \u00e7al\u0131\u015f\u0131rken,  istemin size daha fazla bilgi vermesi, daha okunakl\u0131 ve ki\u015fiselle\u015ftirilmi\u015f olmas\u0131 verimlili\u011finizi art\u0131rabilir. \u0130\u015fte tam bu noktada, <code class=\"language-\">.psqlrc<\/code> dosyas\u0131 devreye giriyor. Bu makalede, Ubuntu 14.04 \u00fczerinde <code class=\"language-\">.psqlrc<\/code> dosyas\u0131n\u0131 kullanarak PostgreSQL komut sat\u0131r\u0131 isteminizi nas\u0131l \u00f6zelle\u015ftirebilece\u011finizi ad\u0131m ad\u0131m \u00f6\u011frenece\u011fiz.  Veritaban\u0131 y\u00f6netiminizi kolayla\u015ft\u0131racak ipu\u00e7lar\u0131 ve ger\u00e7ek d\u00fcnya senaryolar\u0131yla dolu bir rehber sunaca\u011f\u0131z.<\/p>\n<p><strong>PostgreSQL ve psqlrc Temelleri: Nedir ve Nas\u0131l \u00c7al\u0131\u015f\u0131r?<\/strong><\/p>\n<p>PostgreSQL, g\u00fc\u00e7l\u00fc ve pop\u00fcler bir a\u00e7\u0131k kaynak ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir.  <code class=\"language-\">psql<\/code>, PostgreSQL&#8217;in komut sat\u0131r\u0131 arabirimidir.  <code class=\"language-\">.psqlrc<\/code> ise, <code class=\"language-\">psql<\/code> ba\u015flat\u0131ld\u0131\u011f\u0131nda otomatik olarak y\u00fcklenen ve istemin g\u00f6r\u00fcn\u00fcm\u00fcn\u00fc ve davran\u0131\u015f\u0131n\u0131 \u00f6zelle\u015ftirmenize olanak tan\u0131yan bir yap\u0131land\u0131rma dosyas\u0131d\u0131r. Bu dosya sayesinde, isteminize veritaban\u0131 ad\u0131, kullan\u0131c\u0131 ad\u0131, tarih ve saat gibi bilgileri ekleyebilir, renk \u015femas\u0131 de\u011fi\u015ftirebilir ve hatta \u00f6zel komutlar tan\u0131mlayabilirsiniz.  <code class=\"language-\">.psqlrc<\/code> dosyas\u0131, ev dizininizde bulunur ve genellikle gizli bir dosyad\u0131r (<code class=\"language-\">.psqlrc<\/code>).  Bu dosyan\u0131n i\u00e7eri\u011fi, PostgreSQL&#8217;in komut dilinde (SQL) yaz\u0131lan komutlardan olu\u015fur.<\/p>\n<p><strong>psqlrc Dosyas\u0131n\u0131 Olu\u015fturma ve Temel \u00d6zelle\u015ftirmeler: Yeni Ba\u015flayanlar \u0130\u00e7in<\/strong><\/p>\n<p><strong>\u00d6\u011frenme Yol Haritas\u0131: Yeni Ba\u015flayan<\/strong><\/p>\n<p>\u0130lk ad\u0131m olarak, <code class=\"language-\">.psqlrc<\/code> dosyas\u0131n\u0131 olu\u015fturman\u0131z gerekiyor.  Terminalinizi a\u00e7\u0131n ve a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n<pre class=\"language-bash\"><code>touch ~\/.psqlrc<\/code><\/pre>\n<p>Bu komut, ev dizininizde <code class=\"language-\">.psqlrc<\/code> ad\u0131nda bir dosya olu\u015fturur.  \u015eimdi bu dosyay\u0131 bir metin edit\u00f6r\u00fcyle a\u00e7al\u0131m (\u00f6rne\u011fin, <code class=\"language-\">nano<\/code>, <code class=\"language-\">vim<\/code> veya <code class=\"language-\">gedit<\/code>):<\/p>\n<pre class=\"language-bash\"><code>nano ~\/.psqlrc<\/code><\/pre>\n<p>\u015eimdi, isteminizi \u00f6zelle\u015ftirelim.  A\u015fa\u011f\u0131daki kodu <code class=\"language-\">.psqlrc<\/code> dosyas\u0131na ekleyin:<\/p>\n<pre class=\"language-sql\"><code>\\set PROMPT1 '%x'\n\\set PROMPT2 '=&gt; '<\/code><\/pre>\n<p>Bu kod, istemin ba\u015flang\u0131c\u0131na veritaban\u0131 ad\u0131n\u0131 (%x) ve sonuna ise standart bir &#8220;=> &#8221; ekler.  Dosyay\u0131 kaydedin ve <code class=\"language-\">psql<\/code>&#8216;i \u00e7al\u0131\u015ft\u0131r\u0131n.  \u0130steminizin de\u011fi\u015fti\u011fini g\u00f6receksiniz.<\/p>\n<p><strong>Ger\u00e7ek D\u00fcnya \u00d6rne\u011fi:<\/strong>  Birden fazla veritaban\u0131yla \u00e7al\u0131\u015fan bir geli\u015ftiriciyseniz, her veritaban\u0131 i\u00e7in farkl\u0131 bir istem g\u00f6r\u00fcn\u00fcm\u00fc kullanmak, hangi veritaban\u0131nda \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z\u0131 an\u0131nda anlaman\u0131za yard\u0131mc\u0131 olur. \u00d6rne\u011fin,  <code class=\"language-\">production<\/code> veritaban\u0131 i\u00e7in farkl\u0131 bir istem rengi ve <code class=\"language-\">development<\/code> i\u00e7in farkl\u0131 bir istem metni kullanabilirsiniz.<\/p>\n<p><strong>\u0130leri D\u00fczey \u00d6zelle\u015ftirmeler: Tarih, Saat ve Kullan\u0131c\u0131 Bilgileri<\/strong><\/p>\n<p><strong>\u00d6\u011frenme Yol Haritas\u0131: Orta<\/strong><\/p>\n<p>\u0130steminize tarih, saat ve kullan\u0131c\u0131 ad\u0131n\u0131z\u0131 eklemek, \u00e7al\u0131\u015fman\u0131z\u0131 daha organize hale getirir.  Bunun i\u00e7in a\u015fa\u011f\u0131daki kodu <code class=\"language-\">.psqlrc<\/code> dosyan\u0131za ekleyebilirsiniz:<\/p>\n<pre class=\"language-sql\"><code>\\set PROMPT1 '\\h@\\d@\\u@\\t '<\/code><\/pre>\n<p>Bu kod, istemin ba\u015flang\u0131c\u0131na s\u0131ras\u0131yla ana bilgisayar ad\u0131 (<code class=\"language-\">\\h<\/code>), veritaban\u0131 ad\u0131 (<code class=\"language-\">\\d<\/code>), kullan\u0131c\u0131 ad\u0131 (<code class=\"language-\">\\u<\/code>) ve tarihi ve saati (<code class=\"language-\">\\t<\/code>) ekler.  Bu \u00f6zelle\u015ftirme, hangi veritaban\u0131nda, hangi kullan\u0131c\u0131yla ve ne zaman \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z\u0131 an\u0131nda anlaman\u0131z\u0131 sa\u011flar.<\/p>\n<p><strong>Optimizasyon \u0130pu\u00e7lar\u0131:<\/strong>  Uzun istem metinleri ekranda fazla yer kaplayabilir.  \u0130htiyac\u0131n\u0131z olan bilgileri \u00f6zetleyerek, isteminizi okunakl\u0131 tutmaya \u00f6zen g\u00f6sterin.  A\u015f\u0131r\u0131 karma\u015f\u0131k istemler, verimlili\u011finizi d\u00fc\u015f\u00fcrebilir.<\/p>\n<p><strong>Renklendirme ve G\u00f6rsel \u00d6zelle\u015ftirme: psql&#8217;i Daha Kullan\u0131\u015fl\u0131 Hale Getirme<\/strong><\/p>\n<p><strong>\u00d6\u011frenme Yol Haritas\u0131: Orta<\/strong><\/p>\n<p><code class=\"language-\">psql<\/code>&#8216;in varsay\u0131lan renk \u015femas\u0131 herkes i\u00e7in uygun olmayabilir.  <code class=\"language-\">.psqlrc<\/code> dosyas\u0131 sayesinde, istedi\u011finiz renkleri kullanarak isteminizi daha okunakl\u0131 hale getirebilirsiniz.  A\u015fa\u011f\u0131daki kod,  <code class=\"language-\">psql<\/code>&#8216;in renklendirme \u00f6zelli\u011fini etkinle\u015ftirir ve baz\u0131 \u00f6\u011feler i\u00e7in renk tan\u0131mlar:<\/p>\n<pre class=\"language-sql\"><code>\\set ECHO all\n\\pset pager off\n\\set format unaligned\n\\color xterm<\/code><\/pre>\n<p><code class=\"language-\">\\color xterm<\/code>,  Xterm uyumlu bir renk \u015femas\u0131 kullan\u0131r.  Di\u011fer renk \u015femalar\u0131 da mevcuttur, deneyerek sizin i\u00e7in en uygun olan\u0131 bulabilirsiniz.  <code class=\"language-\">\\pset pager off<\/code>,  sorgu sonu\u00e7lar\u0131n\u0131n sayfaland\u0131r\u0131larak g\u00f6sterilmesini engeller. <code class=\"language-\">\\set format unaligned<\/code>,  sorgular\u0131n \u00e7\u0131kt\u0131s\u0131n\u0131n daha temiz g\u00f6r\u00fcnmesini sa\u011flar.<\/p>\n<p><strong>\u00d6zel Fonksiyonlar ve Komutlar Tan\u0131mlama: Verimlili\u011fi Art\u0131rma<\/strong><\/p>\n<p><strong>\u00d6\u011frenme Yol Haritas\u0131: \u0130leri D\u00fczey<\/strong><\/p>\n<p><code class=\"language-\">.psqlrc<\/code> dosyas\u0131nda, s\u0131k kulland\u0131\u011f\u0131n\u0131z SQL komutlar\u0131n\u0131 veya fonksiyonlar\u0131n\u0131 \u00f6zelle\u015ftirilmi\u015f komutlar olarak tan\u0131mlayabilirsiniz.  \u00d6rne\u011fin, belirli bir tablodaki verileri d\u00fczenli olarak sorgulaman\u0131z gerekiyorsa, bunu bir fonksiyon olarak tan\u0131mlayabilirsiniz:<\/p>\n<pre class=\"language-sql\"><code>\\set my_query &quot;SELECT * FROM my_table WHERE column1 = 'value';&quot;\n\\f my_query<\/code><\/pre>\n<p>Art\u0131k <code class=\"language-\">\\my_query<\/code> komutunu \u00e7al\u0131\u015ft\u0131rarak, uzun SQL sorgunuzu tek bir komutla \u00e7al\u0131\u015ft\u0131rabilirsiniz.<\/p>\n<p><strong>Performans Analizi:<\/strong>  Uzun ve karma\u015f\u0131k SQL sorgular\u0131n\u0131 \u00f6zelle\u015ftirilmi\u015f komutlar olarak tan\u0131mlamak, yaz\u0131m hatalar\u0131n\u0131 azalt\u0131r ve performans\u0131 art\u0131rabilir. Ancak, \u00e7ok fazla \u00f6zelle\u015ftirilmi\u015f komut tan\u0131mlamak, dosyan\u0131n okunabilirli\u011fini ve bak\u0131m\u0131n\u0131 zorla\u015ft\u0131rabilir.  Deneyerek, sizin i\u00e7in en uygun dengeyi bulun.<\/p>\n<p><strong>Hata Ay\u0131klama ve Sorun Giderme: S\u0131k Kar\u015f\u0131la\u015f\u0131lan Sorunlar<\/strong><\/p>\n<p><strong>\u00d6\u011frenme Yol Haritas\u0131: \u0130leri D\u00fczey<\/strong><\/p>\n<p><code class=\"language-\">.psqlrc<\/code> dosyan\u0131zda bir hata varsa, <code class=\"language-\">psql<\/code> ba\u015flat\u0131l\u0131rken bir hata mesaj\u0131 alabilirsiniz.  Hata mesaj\u0131n\u0131 dikkatlice inceleyerek, hatan\u0131n kayna\u011f\u0131n\u0131 belirleyebilirsiniz.  Ayr\u0131ca, <code class=\"language-\">psql<\/code>&#8216;i <code class=\"language-\">-E<\/code> se\u00e7ene\u011fiyle ba\u015flatarak, hata mesajlar\u0131n\u0131 daha ayr\u0131nt\u0131l\u0131 olarak g\u00f6rebilirsiniz:<\/p>\n<pre class=\"language-bash\"><code>psql -E<\/code><\/pre>\n<p><strong>Edge Case&#8217;ler:<\/strong>  <code class=\"language-\">.psqlrc<\/code> dosyan\u0131zda kulland\u0131\u011f\u0131n\u0131z de\u011fi\u015fkenler, di\u011fer komutlarla \u00e7ak\u0131\u015fabilir.  Bu t\u00fcr durumlarda, de\u011fi\u015fken isimlerini dikkatlice se\u00e7meniz ve dosyan\u0131z\u0131 d\u00fczenli tutman\u0131z \u00f6nemlidir.  Ayr\u0131ca, farkl\u0131 PostgreSQL s\u00fcr\u00fcmlerinde <code class=\"language-\">.psqlrc<\/code> dosyas\u0131n\u0131n davran\u0131\u015f\u0131 farkl\u0131l\u0131k g\u00f6sterebilir.<\/p>\n<p><strong>Ger\u00e7ek D\u00fcnya Senaryolar\u0131: Vaka Analizleri<\/strong><\/p>\n<p><strong>Vaka 1:<\/strong>  Bir e-ticaret \u015firketinde \u00e7al\u0131\u015fan bir veritaban\u0131 y\u00f6neticisi oldu\u011funuzu d\u00fc\u015f\u00fcn\u00fcn.  Sipari\u015f verilerini i\u00e7eren b\u00fcy\u00fck bir veritaban\u0131n\u0131z var.  <code class=\"language-\">.psqlrc<\/code> dosyas\u0131n\u0131 kullanarak, isteminize veritaban\u0131 ad\u0131n\u0131, kullan\u0131c\u0131 ad\u0131n\u0131, tarih ve saati ve son giri\u015f zaman\u0131n\u0131 ekleyerek, hangi veritaban\u0131nda, hangi kullan\u0131c\u0131yla ve ne zaman \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z\u0131 an\u0131nda g\u00f6rebilirsiniz.  Bu sayede, olas\u0131 sorunlar\u0131 daha h\u0131zl\u0131 tespit edebilir ve daha verimli \u00e7al\u0131\u015fabilirsiniz.<\/p>\n<p><strong>Vaka 2:<\/strong>  Bir yaz\u0131l\u0131m geli\u015ftirme ekibinde \u00e7al\u0131\u015f\u0131yorsunuz ve birden fazla geli\u015ftirici ayn\u0131 veritaban\u0131n\u0131 kullan\u0131yor.  <code class=\"language-\">.psqlrc<\/code> dosyas\u0131n\u0131 kullanarak, her geli\u015ftiricinin kendi renk \u015femas\u0131 ve istem \u00f6zelle\u015ftirmelerini kullanmas\u0131n\u0131 sa\u011flayabilirsiniz.  Bu sayede, ekibin verimlili\u011fi artar ve kar\u0131\u015f\u0131kl\u0131klar \u00f6nlenir.<\/p>\n<p><strong>Sonu\u00e7: Daha Verimli Bir PostgreSQL Deneyimi<\/strong><\/p>\n<p><code class=\"language-\">.psqlrc<\/code> dosyas\u0131, PostgreSQL komut sat\u0131r\u0131 deneyiminizi ki\u015fiselle\u015ftirmenize ve verimlili\u011finizi art\u0131rman\u0131za olanak tan\u0131yan g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r.  Bu makalede \u00f6\u011frendi\u011finiz teknikleri kullanarak, isteminizi ihtiya\u00e7lar\u0131n\u0131za g\u00f6re \u00f6zelle\u015ftirebilir ve veritaban\u0131 y\u00f6netiminizi daha kolay ve keyifli hale getirebilirsiniz.  Daha fazla bilgi ve ipucu i\u00e7in [Fatih Soysal&#8217;\u0131n bloguna](https:\/\/fatihsoysal.com) g\u00f6z atabilirsiniz.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1. <strong><code class=\"language-\">.psqlrc<\/code> dosyas\u0131n\u0131 silersem ne olur?<\/strong>  Varsay\u0131lan PostgreSQL istemi geri d\u00f6ner.<br \/>\n2. <strong><code class=\"language-\">.psqlrc<\/code> dosyas\u0131nda hata varsa ne olur?<\/strong>  <code class=\"language-\">psql<\/code> ba\u015flat\u0131l\u0131rken bir hata mesaj\u0131 al\u0131rs\u0131n\u0131z.<br \/>\n3. <strong>Farkl\u0131 renk \u015femalar\u0131 nas\u0131l kullan\u0131l\u0131r?<\/strong>  <code class=\"language-\">\\color<\/code> komutunu farkl\u0131 renk \u015femalar\u0131yla deneyerek bulabilirsiniz.<br \/>\n4. <strong>\u00d6zelle\u015ftirilmi\u015f komutlar nas\u0131l tan\u0131mlan\u0131r?<\/strong>  <code class=\"language-\">\\set<\/code> komutu kullan\u0131larak de\u011fi\u015fkenler tan\u0131mlanabilir ve bu de\u011fi\u015fkenler <code class=\"language-\">\\f<\/code> komutu ile fonksiyon gibi kullan\u0131labilir.<br \/>\n5. <strong><code class=\"language-\">.psqlrc<\/code> dosyas\u0131n\u0131 di\u011fer makinelere nas\u0131l ta\u015f\u0131yabilirim?<\/strong>  Dosyay\u0131 kopyalay\u0131p hedef makinedeki ev dizininize yap\u0131\u015ft\u0131rabilirsiniz.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL Prompt&#8217;unu psqlrc ile \u00d6zelle\u015ftirme: Ubuntu 14.04 K\u0131lavuzu PostgreSQL ile \u00e7al\u0131\u015f\u0131rken, varsay\u0131lan komut sat\u0131r\u0131 isteminin size yetersiz&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":[1468],"tags":[],"class_list":{"0":"post-30200","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-ubuntu","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>Ubuntu 14.04&#039;te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme<\/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\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ubuntu 14.04&#039;te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-24T19:40:22+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\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Ubuntu 14.04&#8217;te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme\",\"datePublished\":\"2025-09-24T19:40:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/\"},\"wordCount\":1142,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"Ubuntu\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/\",\"name\":\"Ubuntu 14.04'te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-09-24T19:40:22+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ubuntu 14.04&#8217;te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme\"}]},{\"@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":"Ubuntu 14.04'te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme","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\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/","og_locale":"tr_TR","og_type":"article","og_title":"Ubuntu 14.04'te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-09-24T19:40:22+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\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Ubuntu 14.04&#8217;te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme","datePublished":"2025-09-24T19:40:22+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/"},"wordCount":1142,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["Ubuntu"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/","url":"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/","name":"Ubuntu 14.04'te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-09-24T19:40:22+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/ubuntu-14-04te-psqlrc-ile-postgresql-komut-istemini-ozellestirme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Ubuntu 14.04&#8217;te psqlrc ile PostgreSQL Komut \u0130stemini \u00d6zelle\u015ftirme"}]},{"@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\/30200","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=30200"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/30200\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=30200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=30200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=30200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}