{"id":53706,"date":"2023-01-22T20:17:30","date_gmt":"2023-01-22T20:17:30","guid":{"rendered":"https:\/\/dbtut.com\/?p=53706"},"modified":"2023-01-22T20:18:33","modified_gmt":"2023-01-22T20:18:33","slug":"postgresql-data-types","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/","title":{"rendered":"PostgreSQL Data types"},"content":{"rendered":"

In today’s article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs.<\/p>\n

In database operations, there are character, number, date, geometric data types. Let’s talk about character data types from these data.<\/p>\n

For example, you will create a table and enter address information, you can use \u201cvarchar\u201d, text data types for this.<\/p>\n

To give another example, you will create a city column and you do not want this column to be created with more than 20 letters, then you can use data types such as character(20),varchar(20).<\/p>\n

In database systems, data types are required for data to be stored in columns. There is a separate column for your number value, a separate column for characters, separate data types for images, etc.<\/p>\n

We need to make separate definitions for each data, that is, we need to enter separate data types.<\/p>\n

For example, if you are dealing with geographic data, you can choose the path, polygon data type, if you are going to keep mac addresses, we can use macaddr, if you are going to keep monetary data types, we can use money, integer for number, time, timestamp for date data type.<\/p>\n

There are data types and descriptions in the list below, you can use them as needed.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

In today’s article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs. In database operations, there are character, number, date, geometric data types. Let’s talk about character data types from these data. For example, you will create a table and enter address information, you can use \u201cvarchar\u201d, …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":366,"featured_media":53709,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-53706","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nPostgreSQL Data types - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL Data types - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-22T20:17:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-22T20:18:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png\" \/>\n\t<meta property=\"og:image:width\" content=\"648\" \/>\n\t<meta property=\"og:image:height\" content=\"317\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"PostgreSQL Data types\",\"datePublished\":\"2023-01-22T20:17:30+00:00\",\"dateModified\":\"2023-01-22T20:18:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/\"},\"wordCount\":216,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/\",\"name\":\"PostgreSQL Data types - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png\",\"datePublished\":\"2023-01-22T20:17:30+00:00\",\"dateModified\":\"2023-01-22T20:18:33+00:00\",\"description\":\"In today's article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png\",\"width\":648,\"height\":317},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL Data types\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL Data types - Database Tutorials","description":"In today's article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs.","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:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL Data types - Database Tutorials","og_description":"In today's article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/","og_site_name":"Database Tutorials","article_published_time":"2023-01-22T20:17:30+00:00","article_modified_time":"2023-01-22T20:18:33+00:00","og_image":[{"width":648,"height":317,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"PostgreSQL Data types","datePublished":"2023-01-22T20:17:30+00:00","dateModified":"2023-01-22T20:18:33+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/"},"wordCount":216,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/","url":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/","name":"PostgreSQL Data types - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png","datePublished":"2023-01-22T20:17:30+00:00","dateModified":"2023-01-22T20:18:33+00:00","description":"In today's article, I will talk about PostgreSQL Data types to give general information and to meet our basic needs.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/01\/Ekran-goruntusu-2023-01-22-231613.png","width":648,"height":317},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/01\/22\/postgresql-data-types\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL Data types"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53706","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=53706"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53706\/revisions"}],"predecessor-version":[{"id":53710,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53706\/revisions\/53710"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/53709"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=53706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=53706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=53706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}