{"id":683,"date":"2012-04-20T17:24:48","date_gmt":"2012-04-20T22:24:48","guid":{"rendered":"http:\/\/alejandroayala.solmedia.ec\/?p=683"},"modified":"2012-05-14T12:37:47","modified_gmt":"2012-05-14T17:37:47","slug":"postgresql-comandos-utiles-para-el-dia-a-dia","status":"publish","type":"post","link":"https:\/\/alejandroayala.solmedia.ec\/?p=683","title":{"rendered":"PostgreSQL, trabajando d\u00eda a d\u00eda"},"content":{"rendered":"<p>Esta entrada ser\u00e1 actualizada constantemente a fin de ir a\u00f1adiendo las cosas que diaria surgen en la administraci\u00f3n de la base de datos PostgreSQL.<\/p>\n<p>Los comandos m\u00e1s \u00fatiles ser\u00e1n almacenados\u00a0aqu\u00ed\u00a0en esta entrada para que sea de\u00a0f\u00e1cil\u00a0acceso cuando se requiera sacarle partido a alguna caracter\u00edstica importante de este gran gestor de base de datos.<\/p>\n<p><strong>1. Como saber el tama\u00f1o de una columna<\/strong><\/p>\n<p>[sql]SELECT pg_column_size(nombre_columna) FROM tabla;[\/sql]<\/p>\n<p><strong>2. Como calcular el tama\u00f1o de nuestra base de datos: <\/strong>El valor a la salida est\u00e1 dada en bytes.<\/p>\n<p>[sql]SELECT pg_database_size(&#8216;miBD&#8217;);[\/sql]<\/p>\n<p><!--more--><\/p>\n<pre><\/pre>\n<p><strong>3. Actualizar columnas usando CASE WHEN<\/strong><\/p>\n<p>[sql]UPDATE mitabla\u00a0SET campo1 = ( CASE campo2<br \/>\n WHEN &lt;valor&gt; THEN &lt;valor&gt;<br \/>\nWHEN &lt;valor&gt; THEN &lt;valor&gt;<br \/>\nWHEN &lt;valor&gt; THEN &lt;valor&gt; END )<br \/>\n WHERE&#8230;.;[\/sql]<\/p>\n\n<div class=\"twitter-share\"><a href=\"https:\/\/twitter.com\/intent\/tweet?via=a1ejo_ayala\" class=\"twitter-share-button\" data-size=\"large\">Twittear<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Esta entrada ser\u00e1 actualizada constantemente a fin de ir a\u00f1adiendo las cosas que diaria surgen en la administraci\u00f3n de la base de datos PostgreSQL. Los comandos m\u00e1s \u00fatiles ser\u00e1n almacenados\u00a0aqu\u00ed\u00a0en esta entrada para que sea de\u00a0f\u00e1cil\u00a0acceso cuando se requiera sacarle partido a alguna caracter\u00edstica importante de este gran gestor de base de datos. 1. Como\u2026 <span class=\"read-more\"><a href=\"https:\/\/alejandroayala.solmedia.ec\/?p=683\">Leer m\u00e1s &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":686,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[8],"tags":[140,170,172,141,29,142,138,139,507,169,171],"_links":{"self":[{"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/posts\/683"}],"collection":[{"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=683"}],"version-history":[{"count":13,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/posts\/683\/revisions"}],"predecessor-version":[{"id":838,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/posts\/683\/revisions\/838"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=\/wp\/v2\/media\/686"}],"wp:attachment":[{"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alejandroayala.solmedia.ec\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}