{"id":368,"date":"2015-03-25T20:43:16","date_gmt":"2015-03-25T16:13:16","guid":{"rendered":"http:\/\/www.chpert.net\/?p=368"},"modified":"2019-05-29T23:39:36","modified_gmt":"2019-05-29T19:09:36","slug":"%d8%a8%d9%87-%d8%b3%d9%85%d8%aa-postgresql-%d8%b4%d9%84-postgresql","status":"publish","type":"post","link":"https:\/\/pahlevanzadeh.net\/?p=368","title":{"rendered":"\u0628\u0647 \u0633\u0645\u062a PostgreSQL (\u0634\u0644 PostgreSQL)"},"content":{"rendered":"<p>\u0646\u0645\u06cc\u200c\u062f\u0648\u0646\u0645 \u0686\u0631\u0627 \u06a9\u062a\u0627\u0628\u200c\u0647\u0627\u06cc\u06cc \u0628\u0627 \u0639\u0646\u0627\u0648\u06cc\u0646\u06cc \u0645\u062b\u0644 php \u0648 mysql \u0628\u0647 \u06a9\u0631\u0627\u062a \u062f\u0631 \u062f\u0646\u06cc\u0627 \u0686\u0627\u067e \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0627\u0644\u0628\u062a\u0647 \u062e\u0648\u062f \u062c\u0648\u0627\u0628\u0634 \u0645\u0639\u0644\u0648\u0645\u0647\u060c \u0648\u0644\u06cc \u062c\u0627\u06cc \u0628\u0633\u06cc \u062a\u0623\u0633\u0641 \u062f\u0627\u0631\u0647 \u06a9\u0647 \u0627\u06cc\u0646\u0642\u062f\u0631 \u062f\u0646\u06cc\u0627\u06cc \u0648\u0628 \u0631\u0648 \u06a9\u0648\u0686\u06a9 \u0641\u0631\u0636 \u06a9\u0631\u062f \u06a9\u0647 \u06cc\u06a9 mysql \u0648 shared hosting&#8230;. \u062f\u0631 \u06cc\u06a9 \u0628\u0627\u0632\u0647 \u0632\u0645\u0627\u0646\u06cc NoSQL \u0647\u0627(Not Only SQL \u0647\u0627) \u0641\u0631\u0627\u06af\u06cc\u0631 <a   href=\"http:\/\/www.pahlevanzadeh.net\/wp-content\/uploads\/2015\/03\/postgresql_hosting.png\"><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.pahlevanzadeh.net\/wp-content\/uploads\/2015\/03\/postgresql_hosting-300x300.png\" alt=\"postgresql\" width=\"300\" height=\"300\" class=\"alignnone size-medium wp-image-370  alignleft\" srcset=\"https:\/\/pahlevanzadeh.net\/wp-content\/uploads\/2015\/03\/postgresql_hosting.png 300w, https:\/\/pahlevanzadeh.net\/wp-content\/uploads\/2015\/03\/postgresql_hosting-150x150.png 150w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\u0634\u062f\u0646\u062f \u0648 \u06a9\u0644\u06cc \u0627\u062a\u0641\u0627\u0642\u0627\u062a \u0639\u062c\u06cc\u0628 \u0648 \u063a\u0631\u06cc\u0628 \u062f\u06cc\u06af\u0647 \u0627\u0641\u062a\u0627\u062f. \u06cc\u06a9 Database Programmer \u0628\u0631\u0627\u0634 \u0646\u0628\u0627\u06cc\u062f \u0627\u0647\u0645\u06cc\u062a \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0647 \u06a9\u0647 backend \u0642\u0636\u06cc\u0647 \u0686\u06cc\u0647\u060c \u0627\u0644\u0628\u062a\u0647\u060c \u062f\u0631 \u0645\u0648\u0631\u062f \u0686\u0646\u062f \u0686\u06cc\u0632 \u062a\u0627 \u062d\u062f\u06cc \u0641\u0631\u0642 \u0645\u06cc\u200c\u06a9\u0646\u0647 \u0645\u062b\u0644 Data Type \u0647\u0627\u060c \u0646\u0648\u0634\u062a\u0646 Transaction \u060c Trigger \u0648 \u062f\u0633\u062a\u0648\u0631\u0627\u062a sql \u06cc \u062e\u0648\u062f backend \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc\u200c\u06a9\u0646\u0647. \u0627\u06af\u0631 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0641\u0631\u0636\u06cc \u0631\u0648 \u06a9\u0646\u0627\u0631 \u0628\u06af\u0630\u0627\u0631\u06cc\u0645 \u0648\u0627\u0642\u0639\u0627\u064b backend \u0647\u06cc\u0686 \u0641\u0631\u0642\u06cc \u0646\u0645\u06cc\u200c\u06a9\u0646\u0647 \u0648 \u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0631 \u0645\u0642\u06cc\u0627\u0633\u0647 \u06a9\u0647 \u062e\u06cc\u0644\u06cc \u0645\u0647\u0645\u0647.<br \/>\n\u06cc\u06a9\u06cc \u0627\u0632 Database server \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0646\u06cc\u0627 \u0631\u0648 \u062a\u06a9\u0648\u0646 \u062f\u0627\u062f \u0648 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0645\u0627\u06cc\u06a9\u0631\u0648\u0633\u0627\u0641\u062a Skype \u0631\u0648 \u0646\u062e\u0631\u06cc\u062f\u0647 \u0628\u0648\u062f\u060cSkype \u0628\u0627 \u06f9 \u0645\u06cc\u0644\u06cc\u0648\u0646 \u06a9\u0627\u0631\u0628\u0631 online \u0627\u0632 PostgreSQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0631\u062f.<br \/>\n<!--more--><\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0646\u0647 \u0642\u0635\u062f benchmark \u062f\u0627\u0631\u0645 \u0646\u0647 \u0642\u0635\u062f \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0627\u0632 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u062e\u0627\u0635\u06cc\u060c \u0628\u0644\u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0645 \u06a9\u0645\u06a9\u06cc \u06a9\u0631\u062f\u0647 \u0628\u0627\u0634\u0645 \u0628\u0647 \u0627\u0648\u0646\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0646 \u0628\u06cc\u0627\u0646 \u0633\u0645\u062a PostgreSQL \u060c \u0648 \u0634\u0644 \u0627\u0648\u0646 \u0631\u0648 \u0628\u0631\u0627\u0634\u0648\u0646 \u062a\u0648\u0636\u06cc\u062d \u0628\u062f\u0645.<br \/>\n\u0627\u0644\u0628\u062a\u0647 \u06cc\u0647 config \u0627\u0648\u0644\u06cc\u0647 \u0647\u0645 \u062f\u0627\u0631\u0647 \u06a9\u0647 \u06a9\u0644\u0627\u064b \u0647\u0645\u0647 \u0686\u06cc \u0631\u0648 \u06a9\u0627\u0631\u0628\u0631 \u0627\u0632 \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u0628\u0633\u0627\u0632\u0647 \u0645\u062b\u0644 MySQL \u0646\u06cc\u0633\u062a. <\/p>\n<p style=\"font-szie: 18px;\"><strong>\u06f1. config \u0627\u0648\u0644\u06cc\u0647<\/strong><\/p>\n<p>\u062f\u0631 \u0627\u0628\u062a\u062f\u0627 \u0628\u0627 \u06a9\u0627\u0631\u0628\u0631 root \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u0648\u0627\u0631\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">root@debian:\/home\/mohsen# su \u2013 postgres\r\npostgres@debian:~$ pwd\r\n\/var\/lib\/postgresql<\/pre>\n<p>postgresql \u06a9\u0627\u0631\u0628\u0631\u06cc \u062f\u0627\u0631\u062f \u06a9\u0647 \u0647\u0645\u0647 \u06a9\u0627\u0631\u0647\u0627 \u0628\u0627 \u0622\u0646 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u0634\u0648\u062f.<br \/>\n<strong>\u0646\u06a9\u062a\u0647:<\/strong>  \u06cc\u0627\u062f\u062a\u0627\u0646 \u0646\u0631\u0648\u062f \u0627\u0632 \u2013 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f.<br \/>\n<strong>\u0646\u06a9\u062a\u0647:<\/strong> \u062f\u0631 \u0647\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0686\u0646\u062f PostgresSQL \u0627\u0632 \u0637\u0631\u06cc\u0642 repo \u0646\u0635\u0628 \u0634\u0648\u062f \u0628\u0647 \u06f2 \u0645\u0633\u06cc\u0631 \u0632\u06cc\u0631 \u062f\u0642\u062a \u0646\u0645\u0627\u06cc\u06cc\u062f :<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">postgres@debian:~$ ls -dl \/etc\/postgresql\/9.4\/main\/\r\ndrwxr-xr-x 2 postgres postgres 4096 Mar 25 07:55 \/etc\/postgresql\/9.4\/main\/\r\npostgres@debian:~$ ls -dl \/var\/lib\/postgresql\/9.4\/main\/\r\ndrwx------ 18 postgres postgres 4096 Mar 25 07:54 \/var\/lib\/postgresql\/9.4\/main\/<\/pre>\n<p>\u062a\u0627 \u0647\u0645\u06cc\u0646 \u0686\u0646\u062f \u0648\u0642\u062a \u067e\u06cc\u0634 configuration \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \/etc\/ \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u062f\u0631 \/var\/lib\/postgresql\/ \u0628\u0648\u062f\u0646\u062f. \u0627\u0645\u0627 \u0645\u0642\u0635\u0648\u0631 \u0627\u0632 \u0627\u06cc\u0646 \u06f2 \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0648\u0631\u0698\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0635\u0648\u0631\u062a \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u062f\u0631\u0622\u0645\u062f\u0647 \u0627\u0633\u062a. \u0627\u06af\u0631 \u0622\u0646 9.4 \u0646\u0633\u062e\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0628\u0627\u0634\u062f \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0646\u0633\u062e\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0647\u0645 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f. \u062f\u0631\u200c\u0648\u0627\u0642\u0639 \u0634\u0645\u0627 \u0622\u0646 \u0631\u0627 \u06cc\u06a9 \u0645\u062a\u063a\u06cc\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f.<\/p>\n<p style=\"font-size: 17px;\"><strong>\u06f1.\u06f1 \u0641\u0627\u06cc\u0644 pg_hba.conf:<\/strong><\/p>\n<p>\u0647\u0645\u0647 \u0686\u06cc\u0632 \u0628\u0627 \u0627\u06cc\u0646 \u0641\u0627\u06cc\u0644 \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646\u060c\u200c database \u200c\u0647\u0627 \u0648 \u062e\u06cc\u0644\u06cc \u0627\u0632 \u0645\u0633\u0627\u06cc\u0644 \u0627\u0645\u0646\u06cc\u062a\u06cc \u062f\u0631 \u0627\u06cc\u0646 \u0641\u0627\u06cc\u0644 \u0646\u0648\u0634\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<br \/>\n<strong>\u0646\u06a9\u062a\u0647:<\/strong> \u0628\u0646\u0627 \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645\u200c\u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062f\u0631 \/var\/lib\/postgresql\/ \u0628\u0627\u0634\u062f \u0648 \u0627\u06af\u0631 \u0646\u0647 \u062f\u0631 \/etc\/postgresql\/ \u0645\u06cc\u200c\u0628\u0627\u0634\u062f. \u0628\u0627\u0632 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u062a\u0627 \u062d\u062f\u06cc \u0628\u0647 \u0633\u0644\u06cc\u0642\u0647 \u0634\u062e\u0635\u06ccpackage maintenance \u062a\u0648\u0632\u06cc\u0639 \u0634\u0645\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u062f.<br \/>\n\u0627\u06cc\u0646 \u0641\u0627\u06cc\u0644 \u0628\u0647 \u06f5 \u0633\u062a\u0648\u0646 \u0627\u0635\u0644\u06cc \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc\u200c\u06af\u0631\u062f\u062f:<\/p>\n<ul>\n<li style=\"margin-right: 30px;\">\n<p>\n\u0633\u062a\u0648\u0646 \u0627\u0648\u0644: \u0646\u0648\u0639 connection \u06a9\u0627\u0631\u0628\u0631 \u0628\u0647 Database \u0634\u0645\u0627 \u0645\u06cc\u200c\u0628\u0627\u0634\u062f.<\/p>\n<\/li>\n<li style=\"margin-right: 30px;\">\n<p>\n\u0633\u062a\u0648\u0646 \u062f\u0648\u0645: \u0646\u0627\u0645 Database \u0634\u0645\u0627 \u0645\u06cc\u200c\u0628\u0627\u0634\u062f.<\/p>\n<\/li>\n<li style=\"margin-right: 30px;\">\n<p>\n\u0633\u062a\u0648\u0646 \u0633\u0648\u0645: \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0645\u06cc\u200c\u0628\u0627\u0634\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc Database \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0631\u062f\u06cc\u062f.<\/p>\n<\/li>\n<li style=\"margin-right: 30px;\">\n<p>\n\u0633\u062a\u0648\u0646 \u0686\u0647\u0627\u0631\u0645: \u0622\u062f\u0631\u0633\u06cc \u06a9\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0627\u0632 \u0622\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0627\u06cc\u0646 database \u0645\u062a\u0635\u0644 \u06af\u0631\u062f\u062f.<\/p>\n<\/li>\n<li style=\"margin-right: 30px;\">\n<p>\n\u0633\u062a\u0648\u0646 \u067e\u0646\u0686\u0645: \u06a9\u0647 \u0622\u0646 \u0631\u0627 method \u0646\u0627\u0645\u06cc\u062f\u0647\u200c\u0627\u0646\u062f \u062f\u0631\u200c\u0648\u0627\u0642\u0639 \u0646\u0648\u0639 Authentication \u0627\u0633\u062a.<\/p>\n<\/li>\n<\/ul>\n<p>\u0628\u0627 \u062f\u0648 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 database \u0648 \u06a9\u0627\u0631\u0628\u0631 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u0646\u0645\u0627\u06cc\u06cc\u0645:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">postgres@debian:\/etc\/postgresql\/9.4\/main$ createdb chpert.net\r\npostgres@debian:\/etc\/postgresql\/9.4\/main$ createuser chpert.net<\/pre>\n<p>\u0633\u067e\u0633 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0648\u0627\u0631\u062f pg_hba.conf \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">host    chpert.net      chpert.net      127.0.0.1\/32            trust<\/pre>\n<p><strong>\u0646\u06a9\u062a\u0647:<\/strong> \u0627\u0644\u0628\u062a\u0647 \u0645\u0646 \u0646\u06a9\u0627\u062a \u0627\u0645\u0646\u06cc\u062a\u06cc \u0631\u0627 \u0631\u0639\u0627\u06cc\u062a \u0646\u06a9\u0631\u062f\u0647 \u0648 \u0635\u0631\u0641\u0627\u064b \u0642\u0635\u062f \u0622\u0645\u0648\u0632\u0634 \u062f\u0627\u0631\u0645.<br \/>\n\u0633\u067e\u0633:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">root@debian:\/home\/mohsen# service postgresql reload<\/pre>\n<p>\u0633\u067e\u0633 \u0628\u0627 \u0647\u0645\u0627\u0646 \u06a9\u0627\u0631\u0628\u0631 postgres \u0648\u0627\u0631\u062f \u0634\u0644 psql \u0645\u06cc\u200c\u0634\u0648\u06cc\u0645:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">postgres@debian:\/etc\/postgresql\/9.4\/main$ psql \r\npsql (9.4.1)\r\nType \"help\" for help.\r\n\r\npostgres=# <\/pre>\n<p>\u0627\u06cc\u0646\u062c\u0627 \u0646\u0642\u0637\u0647 \u0622\u063a\u0627\u0632 \u0647\u0645\u0647 \u0686\u06cc\u0632 \u0627\u0633\u062a.<\/p>\n<p style=\"font-size: 18px;\"><strong>\u06f2. \u0634\u0644 PostgreSQL<\/strong><\/p>\n<p>\u062d\u0627\u0644 \u06a9\u0647 \u0647\u0645\u0647 \u0686\u06cc\u0632 \u0622\u0645\u0627\u062f\u0647 \u0634\u062f \u0628\u0627\u06cc\u062f \u0628\u062f\u0627\u0646\u06cc\u0645 \u0627\u06cc\u0646\u062c\u0627 MySQL \u0646\u06cc\u0633\u062a \u0648 \u062f\u0633\u062a\u0648\u0631\u0627\u062a\u06cc \u0647\u0645\u0686\u0648\u0646 use \u0648\u062c\u0648\u062f \u062e\u0627\u0631\u062c\u06cc \u0646\u062f\u0627\u0631\u0646\u062f. \u0627\u0645\u0627 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0633\u062a\u0648\u0631\u0627\u062a\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u0646\u062f \u06a9\u0647 \u0628\u0627 backslash \u0634\u0631\u0648\u0639 \u0645\u06cc\u0634\u0648\u0646\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627 \u0645\u062b\u0627\u0644 \\ \u0631\u0627 \u0647\u0645\u0631\u0627 \u0647 \u0628\u0627 \u06f2 \u0628\u0627\u0631 \u06a9\u0644\u06cc\u062f TAB \u0641\u0634\u0631\u062f\u0647 \u0648 \u062e\u0631\u0648\u062c\u06cc \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">postgres=# \\\r\n\\!          \\da         \\dew        \\dL         \\du         \\gset       \\lo_list    \\r          \\x\r\n\\a          \\db         \\df         \\dn         \\dv         \\h          \\lo_unlink  \\set        \\z\r\n\\C          \\dc         \\dF         \\do         \\dx         \\H          \\o          \\sf         \r\n\\cd         \\dC         \\dFd        \\dp         \\e          \\help       \\p          \\t          \r\n\\connect    \\dd         \\dFp        \\drds       \\echo       \\i          \\password   \\T          \r\n\\conninfo   \\dD         \\dFt        \\ds         \\ef         \\ir         \\prompt     \\timing     \r\n\\copy       \\des        \\dg         \\dS         \\encoding   \\l          \\pset       \\unset      \r\n\\copyright  \\det        \\di         \\dt         \\f          \\lo_export  \\q          \\w          \r\n\\d          \\deu        \\dl         \\dT         \\g          \\lo_import  \\qecho      \\watch <\/pre>\n<p>\u0627\u0648\u0644\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 l\\ \u0645\u06cc\u200c\u0628\u0627\u0634\u062f \u06a9\u0647 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627 \u0631\u0627 \u0644\u06cc\u0633\u062a \u0645\u06cc\u200c\u06a9\u0646\u062f:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">chpert.net=# \\l\r\n                                  List of databases\r\n    Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   \r\n------------+----------+----------+-------------+-------------+-----------------------\r\n chpert.net | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | \r\n postgres   | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | \r\n template0  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n            |          |          |             |             | postgres=CTc\/postgres\r\n template1  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n            |          |          |             |             | postgres=CTc\/postgres\r\n(4 rows)\r\n<\/pre>\n<p>\u062d\u0627\u0644 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u06cc\u06a9 \u0628\u0627\u0646\u06a9 \u0648\u0635\u0644 \u0634\u0648\u06cc\u062f:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">postgres=# \\c chpert.net\r\nYou are now connected to database \"chpert.net\" as user \"postgres\".\r\nchpert.net=# <\/pre>\n<p><strong>\u0646\u06a9\u062a\u0647:<\/strong> \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u06a9\u0644 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0627\u06cc\u0646 \u0634\u0644 \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 h\\ \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f. \u06a9\u0647 \u0645\u062e\u0627\u0644\u0641 \u0641\u0634\u0631\u062f\u0646 \\ \u0647\u0645\u0631\u0627\u0647 \u06f2 \u0628\u0627\u0631 TAB \u0645\u06cc\u200c\u0628\u0627\u0634\u062f. \u0627\u06cc\u0646 \u062f\u0648 \u062e\u0631\u0648\u062c\u06cc\u200c\u0647\u0627\u06cc \u0645\u062a\u0641\u0627\u0648\u062a\u06cc \u062f\u0627\u0631\u0646\u062f. \u0627\u0648\u0644\u06cc \u062f\u0633\u062a\u0648\u0631\u0627\u062a\u06cc \u0647\u0645\u0686\u0648\u0646 CREATE TABLE \u0648 \u062f\u0648\u0645\u06cc \u062a\u0645\u0627\u0645 shell command \u0647\u0627 \u0647\u0645\u0627\u0646\u0646\u062f dd\\ \u06cc\u0627 c\\ \u0632\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f.<br \/>\n\u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 table \u0628\u0633\u0627\u0632\u06cc\u0645:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">chpert.net=# create table TEST1(ID  serial not null primary key  , NAME varchar(20) );\r\nCREATE TABLE<\/pre>\n<p>\u06a9\u0644\u0645\u0647 srial \u0628\u0647 \u0645\u0639\u0646\u0627\u06cc \u0647\u0645\u0627\u0646 auto increment \u0645\u06cc\u200c\u0628\u0627\u0634\u062f. \u0648 \u0628\u0642\u06cc\u0647 \u0642\u0636\u0627\u06cc\u0627:<\/p>\n<pre class=\"theme:dark-terminal font:liberation-mono font-size:14 nums:false line-height:20 toolbar:2 scroll:true lang:sh decode:true plain:false\">chpert.net=# \\dt\r\n         List of relations\r\n Schema | Name  | Type  |  Owner   \r\n--------+-------+-------+----------\r\n public | test1 | table | postgres\r\n(1 row)\r\n<\/pre>\n<p><strong>\u0647\u062f\u0641 \u0627\u0632 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0628\u0647 \u0622\u0634\u0646\u0627\u06cc\u06cc \u0627\u0648\u0644\u06cc\u0647 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u06a9\u0631\u062f\u0646 \u0628\u0627 postgresql \u0628\u0648\u062f \u06a9\u0647 \u0627\u0645\u06cc\u062f\u0648\u0627\u0631\u0645 \u0628\u0647 \u062f\u0631\u062f \u062e\u0648\u0631\u062f\u0647 \u0628\u0627\u0634\u0647.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0646\u0645\u06cc\u200c\u062f\u0648\u0646\u0645 \u0686\u0631\u0627 \u06a9\u062a\u0627\u0628\u200c\u0647\u0627\u06cc\u06cc \u0628\u0627 \u0639\u0646\u0627\u0648\u06cc\u0646\u06cc \u0645\u062b\u0644 php \u0648 mysql \u0628\u0647 \u06a9\u0631\u0627\u062a \u062f\u0631 \u062f\u0646\u06cc\u0627 \u0686\u0627\u067e \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u0627\u0644\u0628\u062a\u0647 \u062e\u0648\u062f \u062c\u0648\u0627\u0628\u0634 \u0645\u0639\u0644\u0648\u0645\u0647\u060c \u0648\u0644\u06cc \u062c\u0627\u06cc \u0628\u0633\u06cc \u062a\u0623\u0633\u0641 \u062f\u0627\u0631\u0647 \u06a9\u0647 \u0627\u06cc\u0646\u0642\u062f\u0631 \u062f\u0646\u06cc\u0627\u06cc \u0648\u0628 \u0631\u0648 \u06a9\u0648\u0686\u06a9 \u0641\u0631\u0636 \u06a9\u0631\u062f \u06a9\u0647 \u06cc\u06a9 mysql \u0648 shared hosting&#8230;. \u062f\u0631 \u06cc\u06a9 \u0628\u0627\u0632\u0647 \u0632\u0645\u0627\u0646\u06cc NoSQL \u0647\u0627(Not Only SQL \u0647\u0627) \u0641\u0631\u0627\u06af\u06cc\u0631 \u0634\u062f\u0646\u062f \u0648 \u06a9\u0644\u06cc \u0627\u062a\u0641\u0627\u0642\u0627\u062a \u0639\u062c\u06cc\u0628 \u0648 \u063a\u0631\u06cc\u0628 &hellip; <a href=\"https:\/\/pahlevanzadeh.net\/?p=368\" class=\"more-link\">\u0627\u062f\u0627\u0645\u0647 \u062e\u0648\u0627\u0646\u062f\u0646 <span class=\"screen-reader-text\">\u0628\u0647 \u0633\u0645\u062a PostgreSQL (\u0634\u0644 PostgreSQL)<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110,5,2,111,67,109],"tags":[64,147,65,146,145,62,63],"_links":{"self":[{"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/posts\/368"}],"collection":[{"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=368"}],"version-history":[{"count":10,"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/posts\/368\/revisions"}],"predecessor-version":[{"id":902,"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/posts\/368\/revisions\/902"}],"wp:attachment":[{"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pahlevanzadeh.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}