{"id":54270,"date":"2023-03-31T19:04:13","date_gmt":"2023-03-31T19:04:13","guid":{"rendered":"https:\/\/dbtut.com\/?p=54270"},"modified":"2023-03-31T19:05:39","modified_gmt":"2023-03-31T19:05:39","slug":"postgresql-select","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/","title":{"rendered":"PostgreSQL Select"},"content":{"rendered":"

In today’s article, we will cover What is Select and How to Write a Basic Select Statement.<\/p>\n

Select is a postgresql sentence used to convey the data in the desired column on the Table to the user.<\/p>\n

To explain through an example, you went to the grocery store and there are a lot of fruits and vegetables, but you only want to buy apples and cherries, so you choose apples and cherries from among the many products and tell the grocery store how many kg you will buy.<\/p>\n

The same logic in PostgreSQL, you can select the data in the table according to the column you want and return it to you.<\/p>\n

The usage is as follows:<\/p>\n

SELECT *FROM Table_name<\/pre>\n
Or:<\/p>\n
SELECT Column1, Column2 FROM Table_name<\/pre>\n
When using the SELECT clause, you can select the columns you want to see the data for and write between SELECT and FROM.<\/p>\n
If you are writing more than one column, you need to put a period between them.<\/p>\n
But I want to see the data in all columns and do I have to write them all one by one?<\/p>\n
No, it will be enough to write * between SELECT and FROM for this.<\/p>\n
In the table below, we pull all the records in the Name and Surname columns in the Personnel table.<\/p>\n
SELECT Name,Surname From Personel\r\n<\/pre>\n
We can make various changes on the data with the Select operation.<\/p>\n
In the example below, we have written a select clause to see the sum of the vize and final exam grades of the students in the student table.<\/p>\n
select name, vize+final from student;<\/pre>\n
If you only want to add two numbers, or just want to print text, you can do as in the examples below.<\/p>\n
select 'Faruk  ERDEM'\r\n<\/pre>\n
select 123 + 345\r\n<\/pre>\n
Example:<\/h4>\n
We did the following example using *, and since our table has 3 records and 3 columns, we have 3 columns and 3 records.<\/p>\n
\"\"<\/p>\n
If we want to extract only the name and vize columns, we need to do as follows.<\/p>\n
\"\"<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will cover What is Select and How to Write a Basic Select Statement. Select is a postgresql sentence used to convey the data in the desired column on the Table to the user. To explain through an example, you went to the grocery store and there are a lot of fruits …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":366,"featured_media":54275,"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-54270","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nPostgreSQL Select - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will cover What is Select and How to Write a Basic Select Statement.\" \/>\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\/03\/31\/postgresql-select\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL Select - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will cover What is Select and How to Write a Basic Select Statement.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-31T19:04:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-31T19:05:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.png\" \/>\n\t<meta property=\"og:image:width\" content=\"572\" \/>\n\t<meta property=\"og:image:height\" content=\"320\" \/>\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\/03\/31\/postgresql-select\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"PostgreSQL Select\",\"datePublished\":\"2023-03-31T19:04:13+00:00\",\"dateModified\":\"2023-03-31T19:05:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/\"},\"wordCount\":311,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/\",\"name\":\"PostgreSQL Select - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.png\",\"datePublished\":\"2023-03-31T19:04:13+00:00\",\"dateModified\":\"2023-03-31T19:05:39+00:00\",\"description\":\"In today's article, we will cover What is Select and How to Write a Basic Select Statement.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.png\",\"width\":572,\"height\":320},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL Select\"}]},{\"@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 Select - Database Tutorials","description":"In today's article, we will cover What is Select and How to Write a Basic Select Statement.","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\/03\/31\/postgresql-select\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL Select - Database Tutorials","og_description":"In today's article, we will cover What is Select and How to Write a Basic Select Statement.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/","og_site_name":"Database Tutorials","article_published_time":"2023-03-31T19:04:13+00:00","article_modified_time":"2023-03-31T19:05:39+00:00","og_image":[{"width":572,"height":320,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.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\/03\/31\/postgresql-select\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"PostgreSQL Select","datePublished":"2023-03-31T19:04:13+00:00","dateModified":"2023-03-31T19:05:39+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/"},"wordCount":311,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/","url":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/","name":"PostgreSQL Select - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.png","datePublished":"2023-03-31T19:04:13+00:00","dateModified":"2023-03-31T19:05:39+00:00","description":"In today's article, we will cover What is Select and How to Write a Basic Select Statement.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/03\/Ekran-goruntusu-2023-03-31-220122.png","width":572,"height":320},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/03\/31\/postgresql-select\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL Select"}]},{"@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\/54270","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=54270"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54270\/revisions"}],"predecessor-version":[{"id":54276,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54270\/revisions\/54276"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54275"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}