{"id":28093,"date":"2023-06-25T19:21:05","date_gmt":"2023-06-25T15:51:05","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/play-with-psql-create-table-and-insert-data-for-beginners-27oe\/"},"modified":"2023-06-25T19:21:05","modified_gmt":"2023-06-25T15:51:05","slug":"play-with-psql-create-table-and-insert-data-for-beginners-27oe","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/play-with-psql-create-table-and-insert-data-for-beginners-27oe\/","title":{"rendered":"\u0628\u0627\u0632\u06cc \u0628\u0627 psql &#8211; \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u0648 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 (\u0628\u0631\u0627\u06cc \u0645\u0628\u062a\u062f\u06cc\u0627\u0646)"},"content":{"rendered":"<div data-article-id=\"1515631\" id=\"article-body\">\n<p>\u0633\u0644\u0627\u0645 \u0628\u0686\u0647 \u0647\u0627 \u0627\u0645\u0631\u0648\u0632 \u062f\u0648\u0628\u0627\u0631\u0647 \u0633\u0639\u06cc \u0645\u06cc\u06a9\u0646\u0645 \u062f\u0631 \u0645\u0648\u0631\u062f psql \u0628\u0646\u0648\u06cc\u0633\u0645!  \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u062c\u062f\u0627\u0648\u0644 \u0648 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0627 psql \u0628\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0645\u0646 \u062f\u0631 \u0645\u0648\u0631\u062f \u062a\u0646\u0638\u06cc\u0645\u0627\u062a psql\u060c \u0627\u06cc\u062c\u0627\u062f \u06a9\u0627\u0631\u0628\u0631 \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0631 \u067e\u0633\u062a \u0642\u0628\u0644\u06cc \u0646\u0648\u0634\u062a\u0647 \u0627\u0645\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u0628\u0647 \u0622\u0646 \u067e\u0633\u062a \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644\u060c \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u0648 \u0645\u062c\u0648\u0632\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0648 \u063a\u06cc\u0631\u0647 \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u0645. \u067e\u0633 \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0642\u062f\u0645 \u0628\u0647 \u0642\u062f\u0645 \u0622\u0646\u0647\u0627 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645:D<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/play-with-psql-create-table-and-insert-data-for-beginners-27oe\/#1_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87\" >1. \u0627\u06cc\u062c\u0627\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/play-with-psql-create-table-and-insert-data-for-beginners-27oe\/#%D9%86%DA%A9%D8%AA%D9%87_%D9%81%D8%A7%D8%B5%D9%84%D9%87_%DA%AF%D8%B0%D8%A7%D8%B1%DB%8C\" >\u0646\u06a9\u062a\u0647: \u0641\u0627\u0635\u0644\u0647 \u06af\u0630\u0627\u0631\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/play-with-psql-create-table-and-insert-data-for-beginners-27oe\/#%D9%86%DA%A9%D8%AA%D9%87_template1_%DA%86%DB%8C%D8%B3%D8%AA%D8%9F\" >\u0646\u06a9\u062a\u0647: template1 \u0686\u06cc\u0633\u062a\u061f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/play-with-psql-create-table-and-insert-data-for-beginners-27oe\/#2_%D9%85%D8%AC%D9%88%D8%B2%D9%87%D8%A7%DB%8C_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B1%D8%A7_%D8%A8%D9%87_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1_%D8%A7%D8%B9%D8%B7%D8%A7_%DA%A9%D9%86%DB%8C%D8%AF\" >2. \u0645\u062c\u0648\u0632\u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0627\u0639\u0637\u0627 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/play-with-psql-create-table-and-insert-data-for-beginners-27oe\/#3_%D8%A8%D8%A7_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1_%D8%A8%D9%87_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D9%85%D8%AA%D8%B5%D9%84_%D8%B4%D9%88%DB%8C%D8%AF\" >3. \u0628\u0627 \u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/play-with-psql-create-table-and-insert-data-for-beginners-27oe\/#%D9%86%DA%A9%D8%AA%D9%87_%D8%AE%D8%B7%D8%A7%DB%8C_%D8%B7%D8%B1%D8%AD%D9%88%D8%A7%D8%B1%D9%87\" >\u0646\u06a9\u062a\u0647: \u062e\u0637\u0627\u06cc \u0637\u0631\u062d\u0648\u0627\u0631\u0647<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87\"><\/span>\n<p>  1. \u0627\u06cc\u062c\u0627\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u0648\u0644 \u0627\u0632 \u0647\u0645\u0647\u060c \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0628\u0647 \u06cc\u06a9 \u0627\u0628\u0631\u06a9\u0627\u0631\u0628\u0631 &#8220;postgres&#8221; \u0648\u0627\u0631\u062f \u0634\u0648\u06cc\u062f.  \u0648 \u0633\u067e\u0633 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f <code>CREATE DATABASE &lt;yourdatabasename&gt;<\/code> \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06a9\u0647 \u0645\u0627 \u0628\u0627 \u0622\u0646 \u0628\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0627\u06cc\u0646 \u0628\u0627\u0631 \u0645\u0646 \u0645\u06cc \u062f\u0648\u0645 <code>CREATE DATABASE \"Apple Records\"<\/code>\u060c \u0628\u0647 \u0645\u0646\u0638\u0648\u0631 \u0627\u06cc\u062c\u0627\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0647 \u0646\u0627\u0645 &#8220;Apple Records&#8221;.  \u0648\u0642\u062a\u06cc \u06a9\u0627\u0631\u062a\u0627\u0646 \u062a\u0645\u0627\u0645 \u0634\u062f\u060c \u0628\u062f\u0648\u06cc\u062f <code>\\l<\/code> \u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u0644\u06cc\u0633\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code>                               <span class=\"n\">List<\/span> <span class=\"k\">of<\/span> <span class=\"n\">databases<\/span>\n     <span class=\"n\">Name<\/span>      <span class=\"o\">|<\/span>  <span class=\"k\">Owner<\/span>   <span class=\"o\">|<\/span> <span class=\"k\">Encoding<\/span> <span class=\"o\">|<\/span> <span class=\"k\">Collate<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Ctype<\/span> <span class=\"o\">|<\/span>   <span class=\"k\">Access<\/span> <span class=\"k\">privileges<\/span>   \n<span class=\"c1\">---------------+----------+----------+---------+-------+-----------------------<\/span>\n <span class=\"n\">Apple<\/span> <span class=\"n\">Records<\/span> <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span> <span class=\"o\">|<\/span> <span class=\"n\">UTF8<\/span>     <span class=\"o\">|<\/span> <span class=\"k\">C<\/span>       <span class=\"o\">|<\/span> <span class=\"k\">C<\/span>     <span class=\"o\">|<\/span> \n <span class=\"n\">postgres<\/span>      <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span> <span class=\"o\">|<\/span> <span class=\"n\">UTF8<\/span>     <span class=\"o\">|<\/span> <span class=\"k\">C<\/span>       <span class=\"o\">|<\/span> <span class=\"k\">C<\/span>     <span class=\"o\">|<\/span> \n <span class=\"n\">template0<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span> <span class=\"o\">|<\/span> <span class=\"n\">UTF8<\/span>     <span class=\"o\">|<\/span> <span class=\"k\">C<\/span>       <span class=\"o\">|<\/span> <span class=\"k\">C<\/span>     <span class=\"o\">|<\/span> <span class=\"o\">=<\/span><span class=\"k\">c<\/span><span class=\"o\">\/<\/span><span class=\"n\">postgres<\/span>          <span class=\"o\">+<\/span>\n               <span class=\"o\">|<\/span>          <span class=\"o\">|<\/span>          <span class=\"o\">|<\/span>         <span class=\"o\">|<\/span>       <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span><span class=\"o\">=<\/span><span class=\"n\">CTc<\/span><span class=\"o\">\/<\/span><span class=\"n\">postgres<\/span>\n <span class=\"n\">template1<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span> <span class=\"o\">|<\/span> <span class=\"n\">UTF8<\/span>     <span class=\"o\">|<\/span> <span class=\"k\">C<\/span>       <span class=\"o\">|<\/span> <span class=\"k\">C<\/span>     <span class=\"o\">|<\/span> <span class=\"o\">=<\/span><span class=\"k\">c<\/span><span class=\"o\">\/<\/span><span class=\"n\">postgres<\/span>          <span class=\"o\">+<\/span>\n               <span class=\"o\">|<\/span>          <span class=\"o\">|<\/span>          <span class=\"o\">|<\/span>         <span class=\"o\">|<\/span>       <span class=\"o\">|<\/span> <span class=\"n\">postgres<\/span><span class=\"o\">=<\/span><span class=\"n\">CTc<\/span><span class=\"o\">\/<\/span><span class=\"n\">postgres<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062d\u0627\u0644\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f \u0645\u0646 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0647 \u0646\u0627\u0645 &#8220;Apple Records&#8221; \u062f\u0631 \u0644\u06cc\u0633\u062a \u062f\u0627\u0631\u0645!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%86%DA%A9%D8%AA%D9%87_%D9%81%D8%A7%D8%B5%D9%84%D9%87_%DA%AF%D8%B0%D8%A7%D8%B1%DB%8C\"><\/span>\n<p>  \u0646\u06a9\u062a\u0647: \u0641\u0627\u0635\u0644\u0647 \u06af\u0630\u0627\u0631\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0632 \u0641\u0627\u0635\u0644\u0647 \u062f\u0631 \u0646\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0627\u0632 &#8220;&#8221; \u0628\u0631\u0627\u06cc \u0645\u062d\u0635\u0648\u0631 \u06a9\u0631\u062f\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.  \u067e\u0633\u0646\u062f\u06cc\u062f\u0646\u060c <code>CREATE DATABASE \"Apple Records\";<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%86%DA%A9%D8%AA%D9%87_template1_%DA%86%DB%8C%D8%B3%D8%AA%D8%9F\"><\/span>\n<p>  \u0646\u06a9\u062a\u0647: template1 \u0686\u06cc\u0633\u062a\u061f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 PostgreSQL\u060c template1 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0642\u0627\u0644\u0628 \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0639\u0645\u0644 \u0645\u06cc \u06a9\u0646\u062f <strong>\u0646\u0642\u0634\u0647<\/strong> \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u062f\u06cc\u062f  \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f\u060c \u0628\u0631 \u0627\u0633\u0627\u0633 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0642\u0627\u0644\u0628 \u0645\u0634\u062e\u0635 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 template1 \u0627\u063a\u0644\u0628 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0627\u0644\u06af\u0648\u06cc \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0647 \u0639\u0645\u0642 \u0622\u0646 \u0646\u0645\u06cc \u067e\u0631\u062f\u0627\u0632\u0645.  \u0627\u0645\u0627 \u0627\u06af\u0631 \u0639\u0644\u0627\u0642\u0647 \u0645\u0646\u062f \u0647\u0633\u062a\u06cc\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062e\u0648\u062f\u062a\u0627\u0646 \u0622\u0646 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_%D9%85%D8%AC%D9%88%D8%B2%D9%87%D8%A7%DB%8C_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D8%B1%D8%A7_%D8%A8%D9%87_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1_%D8%A7%D8%B9%D8%B7%D8%A7_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  2. \u0645\u062c\u0648\u0632\u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0627\u0639\u0637\u0627 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c \u0645\u062c\u0648\u0632\u0647\u0627\u06cc \u0644\u0627\u0632\u0645 \u0631\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 koshirok \u0628\u062f\u0647\u06cc\u062f (\u0627\u06cc\u0646 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0645\u0646 \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u0634\u0645\u0627 \u0627\u0632 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u062e\u0648\u062f \u06a9\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f).  \u0627\u06af\u0631 \u0647\u0646\u0648\u0632 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0646\u062f\u0627\u0631\u06cc\u062f\u060c \u0644\u0637\u0641\u0627\u064b \u0628\u0647 \u0645\u0642\u0627\u0644\u0647 \u0642\u0628\u0644\u06cc \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0631\u062f\u0647 \u0648 \u0645\u0648\u0631\u062f \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u0639\u0637\u0627\u06cc \u0645\u062c\u0648\u0632\u060c \u06a9\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<p><code>GRANT ALL PRIVILEGES ON DATABASE \"Apple Records\" TO &lt;username&gt;;<br \/><\/code><\/p>\n<p>\u062f\u0631 \u0645\u0648\u0631\u062f \u0645\u0646 \u0642\u0628\u0644\u0627\u064b \u06a9\u0627\u0631\u0628\u0631\u06cc \u0628\u0647 \u0646\u0627\u0645 &#8220;koshirok&#8221; \u062f\u0627\u0631\u0645\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u0645 <code>GRANT ALL PRIVILEGES ON DATABASE \"Apple Records\" TO koshirok;<\/code><\/p>\n<p><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_%D8%A8%D8%A7_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1_%D8%A8%D9%87_%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D9%85%D8%AA%D8%B5%D9%84_%D8%B4%D9%88%DB%8C%D8%AF\"><\/span>\n<p>  3. \u0628\u0627 \u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0627\u0632 superuser &#8220;postgres&#8221; \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u062c\u062f\u06cc\u062f \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u062f\u0647\u06cc\u0645.  \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <code>\\c<\/code> (c \u0628\u0647 \u0645\u0639\u0646\u0627\u06cc \u0627\u062a\u0635\u0627\u0644) \u062f\u0633\u062a\u0648\u0631 \u0645\u0627\u0646\u0646\u062f \u0632\u06cc\u0631.<\/p>\n<p><code>\\c &lt;databasename&gt; &lt;username&gt;<\/code><\/p>\n<p>\u06cc\u0627\u060c \u0634\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \\q \u0631\u0627 \u0628\u0647 \u06a9\u0627\u0645\u0644\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f \u0648 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f. <\/p>\n<p><code>psql -U &lt;username&gt; -d &lt;databasename&gt;<br \/><\/code><br \/>\u0627\u0632 \u062e\u0627\u0631\u062c \u0627\u0632 psql.  \u0647\u0631 \u062f\u0648 \u06cc\u0639\u0646\u06cc \u06cc\u06a9\u0633\u0627\u0646<\/p>\n<p>\u0627\u06af\u0631 \u06a9\u0627\u0631 \u06a9\u0631\u062f\u060c \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062e\u0648\u062f \u0631\u0627 \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631 \u0645\u062c\u0627\u0632 \u06a9\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f \u0645\u062a\u0635\u0644 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f.  \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0622\u0645\u0627\u062f\u0647 \u0634\u0631\u0648\u0639 \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u0647\u0633\u062a\u06cc\u062f!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%86%DA%A9%D8%AA%D9%87_%D8%AE%D8%B7%D8%A7%DB%8C_%D8%B7%D8%B1%D8%AD%D9%88%D8%A7%D8%B1%D9%87\"><\/span>\n<p>  \u0646\u06a9\u062a\u0647: \u062e\u0637\u0627\u06cc \u0637\u0631\u062d\u0648\u0627\u0631\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0639\u062f \u0627\u0632 \u0627\u06cc\u0646 \u0642\u0633\u0645\u062a \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u062f.  \u062f\u0631 \u0645\u0648\u0631\u062f \u0645\u0646\u060c \u0647\u0646\u06af\u0627\u0645 \u0627\u062c\u0631\u0627\u06cc \u062f\u0633\u062a\u0648\u0631 CREATE TABLE \u0628\u0627 \u062e\u0637\u0627\u06cc &#8220;ERROR: Permission Denied for schema Public&#8221; \u0645\u0648\u0627\u062c\u0647 \u0634\u062f\u0645.<\/p>\n<p>\u062f\u0631 \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0631\u062f\u060c \u06a9\u0627\u0631\u0628\u0631 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0627\u06cc\u0646 \u0645\u0634\u06a9\u0644 \u0631\u0627 \u0628\u0631\u0637\u0631\u0641 \u06a9\u0646\u062f: <code>GRANT CREATE ON SCHEMA public TO &lt;username&gt;;<\/code> \u0627\u0632 superuser &#8220;postgres&#8221;\u060c \u0627\u0645\u0627 \u0645\u0646 \u0646\u062a\u0648\u0627\u0646\u0633\u062a\u0645 \u0622\u0646 \u0631\u0627 \u0628\u0631\u0637\u0631\u0641 \u06a9\u0646\u0645 (\u06cc\u06a9 \u067e\u06cc\u0627\u0645 \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0631\u062f\u0645 <code>WARNING:  no privileges were granted for \"public\"<\/code>\u0648 \u062f\u0631\u06cc\u0627\u0641\u062a \u0647\u0645\u0627\u0646 \u062e\u0637\u0627).<\/p>\n<p>\u0645\u062a\u0623\u0633\u0641\u0645 \u06a9\u0647 \u0627\u06cc\u0646 \u0631\u0627 \u0645\u06cc \u06af\u0648\u06cc\u0645\u060c \u0627\u0645\u0627 \u0647\u0646\u0648\u0632 \u0646\u0645\u06cc \u062f\u0627\u0646\u0645 \u062f\u0644\u06cc\u0644 \u0622\u0646 \u0686\u0647 \u0628\u0648\u062f\u0647 \u0627\u0633\u062a &#8211; \u0627\u0645\u0627 \u062d\u062f\u0627\u0642\u0644 \u0631\u0627\u0647 \u062d\u0644 \u0631\u0627 \u0628\u0627 \u0627\u06cc\u062c\u0627\u062f \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u062c\u062f\u06cc\u062f \u0645\u0627\u0646\u0646\u062f \u0627\u06cc\u0646 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0645:<\/p>\n<p><code>CREATE SCHEMA &lt;schemaname&gt;;<br \/><\/code><br \/>\u0648<\/p>\n<p><code>GRANT USAGE, CREATE ON SCHEMA &lt;schemaname&gt; TO &lt;username&gt;;<br \/><\/code><\/p>\n<p>\u067e\u0633 \u0627\u0632 \u0627\u06cc\u0646\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u0645 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u062f\u0648\u0646 \u062e\u0637\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u0645.  \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0627\u06af\u0631 \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f \u0628\u0627 \u0647\u0645\u0627\u0646 \u062e\u0637\u0627 \u0645\u0648\u0627\u062c\u0647 \u0634\u062f\u06cc\u062f\u060c \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0631\u0627 \u0627\u0645\u062a\u062d\u0627\u0646 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0645\u06cc\u0632 \u0634\u0645\u0627 \u0631\u0627 \u0628\u0633\u0627\u0632\u06cc\u0645!<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u062c\u062f\u0648\u0644\u06cc \u0628\u0647 \u0646\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u0645 <strong>\u0628\u06cc\u062a\u0644\u0632<\/strong>\u060c \u06a9\u0647 \u0647\u0645\u0647 \u0627\u0639\u0636\u0627\u06cc \u06af\u0631\u0648\u0647 \u0631\u0627 \u0628\u0627 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0634\u062e\u0635\u06cc \u062f\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631 \u062f\u0627\u0631\u062f.  \u0627\u0645\u0627 \u0642\u0628\u0644 \u0627\u0632 \u0622\u0646\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0648 \u067e\u0627\u06cc\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">Beatles<\/span> <span class=\"p\">(<\/span> <span class=\"n\">id<\/span> <span class=\"nb\">SERIAL<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">100<\/span><span class=\"p\">),<\/span> <span class=\"n\">height<\/span> <span class=\"nb\">DECIMAL<\/span><span class=\"p\">,<\/span> <span class=\"n\">weight<\/span> <span class=\"nb\">DECIMAL<\/span><span class=\"p\">,<\/span> <span class=\"n\">instrument<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">100<\/span><span class=\"p\">),<\/span> <span class=\"n\">birth_place<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">100<\/span><span class=\"p\">),<\/span> <span class=\"n\">active_years<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">100<\/span><span class=\"p\">)<\/span> <span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u0633\u0631\u06cc\u0627\u0644:<\/strong><br \/>SERIAL \u06cc\u06a9 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0639\u062f\u0627\u062f \u0645\u062a\u0648\u0627\u0644\u06cc \u0627\u0633\u062a.  \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0628\u0631\u0627\u06cc \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<br \/>PRIMARY KEY \u0645\u062d\u062f\u0648\u062f\u06cc\u062a\u06cc \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0627\u0633\u062a \u0648 \u0631\u06a9\u0648\u0631\u062f \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0622\u0646 \u0633\u062a\u0648\u0646 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p><strong>VARCHAR(100):<\/strong><br \/>VARCHAR \u06cc\u06a9 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0631\u0634\u062a\u0647 \u0627\u06cc \u0628\u0627 \u0637\u0648\u0644 \u0645\u062a\u063a\u06cc\u0631 \u0627\u0633\u062a.  \u0627\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0631\u0634\u062a\u0647 \u0647\u0627 \u0631\u0627 \u062a\u0627 \u06cc\u06a9 \u0637\u0648\u0644 \u0645\u0634\u062e\u0635 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f.  (100) \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062d\u062f\u0627\u06a9\u062b\u0631 \u0637\u0648\u0644 \u06cc\u06a9 \u0633\u062a\u0648\u0646 VARCHAR \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f.  \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a \u062a\u0627 100 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631 \u0642\u0627\u0628\u0644 \u0630\u062e\u06cc\u0631\u0647 \u0627\u0633\u062a.<\/p>\n<p><strong>\u0627\u0639\u0634\u0627\u0631\u06cc:<\/strong><br \/>DECIMAL \u06cc\u06a9 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u0639\u062f\u062f \u0645\u0645\u06cc\u0632 \u0634\u0646\u0627\u0648\u0631 \u0628\u0627 \u062f\u0642\u062a \u062b\u0627\u0628\u062a \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f.  \u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0642\u062a \u0646\u0642\u0637\u0647 \u0627\u0639\u0634\u0627\u0631 \u0631\u0627 \u0628\u0627 \u062a\u0639\u062f\u0627\u062f \u062b\u0627\u0628\u062a\u06cc \u0627\u0632 \u0627\u0631\u0642\u0627\u0645 \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u062c\u062f\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a!  \u0627\u0645\u0627 \u0647\u0646\u0648\u0632 \u0639\u0636\u0648\u06cc \u0627\u0632 \u06af\u0631\u0648\u0647 \u0646\u062f\u0627\u0631\u062f.  \u067e\u0633 \u0628\u06cc\u0627\u06cc\u06cc\u062f <code>INSERT<\/code> \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0622\u0646<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">Beatles<\/span> <span class=\"p\">(<\/span><span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"n\">height<\/span><span class=\"p\">,<\/span> <span class=\"n\">weight<\/span><span class=\"p\">,<\/span> <span class=\"n\">instrument<\/span><span class=\"p\">,<\/span> <span class=\"n\">birth_place<\/span><span class=\"p\">,<\/span> <span class=\"n\">active_years<\/span><span class=\"p\">)<\/span>\n<span class=\"k\">VALUES<\/span> <span class=\"p\">(<\/span><span class=\"s1\">'John Lennon'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">179<\/span><span class=\"p\">,<\/span> <span class=\"mi\">70<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Vocals, Guitar'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Liverpool, England'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'1960-1970'<\/span><span class=\"p\">),<\/span>\n       <span class=\"p\">(<\/span><span class=\"s1\">'Paul McCartney'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">180<\/span><span class=\"p\">,<\/span> <span class=\"mi\">68<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Vocals, Bass'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Liverpool, England'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'1960-1970'<\/span><span class=\"p\">),<\/span>\n       <span class=\"p\">(<\/span><span class=\"s1\">'George Harrison'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">178<\/span><span class=\"p\">,<\/span> <span class=\"mi\">68<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Vocals, Guitar'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Liverpool, England'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'1960-1970'<\/span><span class=\"p\">),<\/span>\n       <span class=\"p\">(<\/span><span class=\"s1\">'Ringo Starr'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">173<\/span><span class=\"p\">,<\/span> <span class=\"mi\">65<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Vocals, Drums'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Liverpool, England'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'1962-1970'<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0647\u0645\u0647 \u0686\u06cc\u0632 \u0622\u0645\u0627\u062f\u0647 \u0627\u0633\u062a!  \u0628\u0631\u06cc\u0645 \u0628\u062f\u0648\u06cc\u0645 <code>SELECT * FROM Beatles;<\/code> \u0628\u0631\u0627\u06cc \u062f\u06cc\u062f\u0646 \u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code> <span class=\"n\">id<\/span> <span class=\"o\">|<\/span>      <span class=\"n\">name<\/span>       <span class=\"o\">|<\/span> <span class=\"n\">height<\/span> <span class=\"o\">|<\/span> <span class=\"n\">weight<\/span> <span class=\"o\">|<\/span>   <span class=\"n\">instrument<\/span>   <span class=\"o\">|<\/span>    <span class=\"n\">birth_place<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">active_years<\/span> \n<span class=\"c1\">----+-----------------+--------+--------+----------------+--------------------+--------------<\/span>\n  <span class=\"mi\">1<\/span> <span class=\"o\">|<\/span> <span class=\"n\">John<\/span> <span class=\"n\">Lennon<\/span>     <span class=\"o\">|<\/span>    <span class=\"mi\">179<\/span> <span class=\"o\">|<\/span>     <span class=\"mi\">70<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Vocals<\/span><span class=\"p\">,<\/span> <span class=\"n\">Guitar<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Liverpool<\/span><span class=\"p\">,<\/span> <span class=\"n\">England<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">1960<\/span><span class=\"o\">-<\/span><span class=\"mi\">1970<\/span>\n  <span class=\"mi\">2<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Paul<\/span> <span class=\"n\">McCartney<\/span>  <span class=\"o\">|<\/span>    <span class=\"mi\">180<\/span> <span class=\"o\">|<\/span>     <span class=\"mi\">68<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Vocals<\/span><span class=\"p\">,<\/span> <span class=\"n\">Bass<\/span>   <span class=\"o\">|<\/span> <span class=\"n\">Liverpool<\/span><span class=\"p\">,<\/span> <span class=\"n\">England<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">1960<\/span><span class=\"o\">-<\/span><span class=\"mi\">1970<\/span>\n  <span class=\"mi\">3<\/span> <span class=\"o\">|<\/span> <span class=\"n\">George<\/span> <span class=\"n\">Harrison<\/span> <span class=\"o\">|<\/span>    <span class=\"mi\">178<\/span> <span class=\"o\">|<\/span>     <span class=\"mi\">68<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Vocals<\/span><span class=\"p\">,<\/span> <span class=\"n\">Guitar<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Liverpool<\/span><span class=\"p\">,<\/span> <span class=\"n\">England<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">1960<\/span><span class=\"o\">-<\/span><span class=\"mi\">1970<\/span>\n  <span class=\"mi\">4<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Ringo<\/span> <span class=\"n\">Starr<\/span>     <span class=\"o\">|<\/span>    <span class=\"mi\">173<\/span> <span class=\"o\">|<\/span>     <span class=\"mi\">65<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Vocals<\/span><span class=\"p\">,<\/span> <span class=\"n\">Drums<\/span>  <span class=\"o\">|<\/span> <span class=\"n\">Liverpool<\/span><span class=\"p\">,<\/span> <span class=\"n\">England<\/span> <span class=\"o\">|<\/span> <span class=\"mi\">1962<\/span><span class=\"o\">-<\/span><span class=\"mi\">1970<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/06\/1687708265_697_\u0628\u0627\u0632\u06cc-\u0628\u0627-psql-\u0627\u06cc\u062c\u0627\u062f-\u062c\u062f\u0648\u0644-\u0648-\u062f\u0631\u062c-\u062f\u0627\u062f\u0647-\u0628\u0631\u0627\u06cc.png\" alt=\"\u062a\u0648\u0636\u06cc\u062d\u0627\u062a \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"800\" height=\"533\" title=\"\"><\/p>\n<p>\u0645\u0646 \u0645\u06cc \u062e\u0648\u0627\u0633\u062a\u0645 \u062f\u0631 \u0645\u0648\u0631\u062f \u062d\u0630\u0641 \u0648 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u062c\u062f\u0648\u0644 \u0628\u0646\u0648\u06cc\u0633\u0645\u060c \u0627\u0645\u0627 \u0627\u0645\u06cc\u062f\u0648\u0627\u0631\u0645 \u0628\u062a\u0648\u0627\u0646\u0645 \u06cc\u06a9 \u0628\u0627\u0631 \u062f\u06cc\u06af\u0631 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0645.  \u0645\u0645\u0646\u0648\u0646 \u06a9\u0647 \u062e\u0648\u0627\u0646\u062f\u06cc\u062f\u060c \u06a9\u062f\u0646\u0648\u06cc\u0633\u06cc \u0645\u0628\u0627\u0631\u06a9 \ud83d\ude42<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0633\u0644\u0627\u0645 \u0628\u0686\u0647 \u0647\u0627 \u0627\u0645\u0631\u0648\u0632 \u062f\u0648\u0628\u0627\u0631\u0647 \u0633\u0639\u06cc \u0645\u06cc\u06a9\u0646\u0645 \u062f\u0631 \u0645\u0648\u0631\u062f psql \u0628\u0646\u0648\u06cc\u0633\u0645! \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u062c\u062f\u0627\u0648\u0644 \u0648 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0627 psql \u0628\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645. \u0645\u0646 \u062f\u0631 \u0645\u0648\u0631\u062f \u062a\u0646\u0638\u06cc\u0645\u0627\u062a psql\u060c \u0627\u06cc\u062c\u0627\u062f \u06a9\u0627\u0631\u0628\u0631 \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0631 \u067e\u0633\u062a \u0642\u0628\u0644\u06cc \u0646\u0648\u0634\u062a\u0647 \u0627\u0645\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u0628\u0647 \u0622\u0646 \u067e\u0633\u062a \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0646\u06cc\u062f. \u0642\u0628\u0644 \u0627\u0632 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":28094,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-28093","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/28093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=28093"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/28093\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/28094"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=28093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=28093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=28093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}