{"id":224,"date":"2025-07-16T05:39:20","date_gmt":"2025-07-16T05:39:20","guid":{"rendered":"https:\/\/myanmar.ca\/intern\/?p=224"},"modified":"2025-07-17T04:30:22","modified_gmt":"2025-07-17T04:30:22","slug":"postgresql-%e1%80%94%e1%80%b2%e1%80%b7-visual-studio-codevs-code-%e1%80%99%e1%80%be%e1%80%ac-ai-%e1%80%94%e1%80%b2%e1%80%b7-management-%e1%80%9c%e1%80%af%e1%80%95%e1%80%ba%e1%80%9b%e1%80%94%e1%80%ba","status":"publish","type":"post","link":"https:\/\/myanmar.ca\/intern\/2025\/07\/16\/postgresql-%e1%80%94%e1%80%b2%e1%80%b7-visual-studio-codevs-code-%e1%80%99%e1%80%be%e1%80%ac-ai-%e1%80%94%e1%80%b2%e1%80%b7-management-%e1%80%9c%e1%80%af%e1%80%95%e1%80%ba%e1%80%9b%e1%80%94%e1%80%ba\/","title":{"rendered":"PostgreSQL \u1014\u1032\u1037 Visual Studio Code(VS Code) \u1019\u103e\u102c AI \u1014\u1032\u1037 Management \u101c\u102f\u1015\u103a\u101b\u1014\u103a (16.7.2025)"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-medium wp-image-225\" src=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/Circle-Logo-300x300.png\" alt=\"\" width=\"300\" height=\"300\" srcset=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/Circle-Logo-300x300.png 300w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/Circle-Logo-150x150.png 150w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/Circle-Logo.png 500w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ol>\n<li style=\"text-align: left;\">\u1019\u1021\u1031\u1038\u1019\u102d\u102f\u1037\u100c\u1031\u1038\u1019\u103e Database \u1010\u103d\u1031 \u1011\u100a\u1037\u103a\u101b\u1014\u103a\u104b Data Export and Import \u101c\u102f\u1015\u103a\u101b\u1014\u103a\u104b<\/li>\n<li style=\"text-align: left;\">\u1000\u102d\u102f\u101c\u1004\u103a\u1038\u1011\u103d\u100b\u103a\u1000\u103b\u1031\u102c\u103a\u1014\u103e\u1004\u1037\u103a Intern \u1019\u103e user \u101b\u103e\u102c \u1010\u1032\u1037 \u1005\u102c\u1015\u1031\u102b\u103a\u1000\u102d\u102f\u1019\u1030\u1010\u100a\u103a\u1015\u103c\u102e\u1038 \u1021\u101c\u102f\u1015\u103a\u101c\u102f\u1015\u103a\u1014\u102d\u102f\u1004\u103a\u1021\u1031\u102c\u1004\u103a VS code \u1019\u103e\u102c PostgreSQL Algorithm \u101e\u102f\u1036\u1038\u1015\u103c\u102e\u1038\u1010\u1031\u102c\u1037 \u00a0AI \u1000\u102d\u102f\u1019\u1031\u1038\u101b\u1014\u103a \u1014\u1032\u1037 coding \u101b\u1031\u1038\u101b\u1014\u103a \u104b<\/li>\n<li style=\"text-align: left;\">User \u1019\u103e \u101c\u102d\u102f\u1021\u1015\u103a\u101e\u1031\u102c data \u1019\u103b\u102c\u1038\u101b\u103e\u102c\u1019\u100a\u103a\u104b<\/li>\n<\/ol>\n<p>(\u1041\u1046-\u1047-\u1042\u1040\u1042\u1045)<\/p>\n<ul>\n<li style=\"text-align: left;\">PostgreSQL install \u101c\u102f\u1015\u103a\u1015\u103c\u102e\u1038 Table and Data \u101c\u103b\u103e\u1031\u102c\u1000\u103a\u1015\u103c\u102e\u1038\u1015\u102b\u1015\u103c\u102e\u104b<\/li>\n<li style=\"text-align: left;\">Local \u1000 PostgreSQL\u00a0 Server \u1014\u1032\u1037 Visual Studio Code \u1001\u103b\u102d\u1010\u103a\u1015\u102b\u1015\u103c\u102e\u104b \u1019\u1021\u1031\u1038\u1019\u102d\u102f\u1037\u1019\u103e \u1015\u1031\u1038\u101e\u1031\u102c data \u1000\u102d\u102f PostgreSQL\u00a0 Server\u1010\u103d\u1004\u103a\u00a0 import \u101c\u102f\u1015\u103a\u104d \u1019\u101b\u101e\u1031\u1038\u1015\u102b\u104b Miscrosoft \u1000 \u1011\u102f\u1010\u103a\u1010\u1032\u1037 PostgreSQL extension \u1014\u1032\u1037 Local\u00a0 \u1014\u1032\u1037 \u1001\u103b\u102d\u1010\u103a\u1015\u102b\u1015\u103c\u102e\u104b<\/li>\n<\/ul>\n<p>postgre in local terminal<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-251\" src=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/1-1-300x242.png\" alt=\"\" width=\"300\" height=\"242\" srcset=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/1-1-300x242.png 300w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/1-1-768x619.png 768w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/1-1.png 886w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>need to fill password when connect with pgAdmin app<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-253\" src=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/viber_image_2025-07-16_16-44-51-485-2-300x126.png\" alt=\"\" width=\"300\" height=\"126\" srcset=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/viber_image_2025-07-16_16-44-51-485-2-300x126.png 300w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/viber_image_2025-07-16_16-44-51-485-2-1024x429.png 1024w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/viber_image_2025-07-16_16-44-51-485-2-768x321.png 768w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/viber_image_2025-07-16_16-44-51-485-2-1536x643.png 1536w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/viber_image_2025-07-16_16-44-51-485-2-2048x857.png 2048w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>connect postgre in pgAdmin<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-254\" src=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1043png-2-300x126.png\" alt=\"\" width=\"300\" height=\"126\" srcset=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1043png-2-300x126.png 300w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1043png-2-1024x429.png 1024w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1043png-2-768x321.png 768w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1043png-2-1536x643.png 1536w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1043png-2-2048x857.png 2048w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>postgre run in VS code with postgreSQL extention<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-255\" src=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1044-1-300x242.png\" alt=\"\" width=\"300\" height=\"242\" srcset=\"https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1044-1-300x242.png 300w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1044-1-768x619.png 768w, https:\/\/myanmar.ca\/intern\/wp-content\/uploads\/2025\/07\/\u1044-1.png 886w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u1019\u1021\u1031\u1038\u1019\u102d\u102f\u1037\u100c\u1031\u1038\u1019\u103e Database \u1010\u103d\u1031 \u1011\u100a\u1037\u103a\u101b\u1014\u103a\u104b Data Export and Import \u101c\u102f\u1015\u103a\u101b\u1014\u103a\u104b \u1000\u102d\u102f\u101c\u1004\u103a\u1038\u1011\u103d\u100b\u103a\u1000\u103b\u1031\u102c\u103a\u1014\u103e\u1004\u1037\u103a Intern \u1019\u103e user \u101b\u103e\u102c \u1010\u1032\u1037 \u1005\u102c\u1015\u1031\u102b\u103a\u1000\u102d\u102f\u1019\u1030\u1010\u100a\u103a\u1015\u103c\u102e\u1038 \u1021\u101c\u102f\u1015\u103a\u101c\u102f\u1015\u103a\u1014\u102d\u102f\u1004\u103a\u1021\u1031\u102c\u1004\u103a VS code \u1019\u103e\u102c PostgreSQL Algorithm \u101e\u102f\u1036\u1038\u1015\u103c\u102e\u1038\u1010\u1031\u102c\u1037 \u00a0AI \u1000\u102d\u102f\u1019\u1031\u1038\u101b\u1014\u103a \u1014\u1032\u1037 coding \u101b\u1031\u1038\u101b\u1014\u103a \u104b User \u1019\u103e \u101c\u102d\u102f\u1021\u1015\u103a\u101e\u1031\u102c data \u1019\u103b\u102c\u1038\u101b\u103e\u102c\u1019\u100a\u103a\u104b (\u1041\u1046-\u1047-\u1042\u1040\u1042\u1045) PostgreSQL install \u101c\u102f\u1015\u103a\u1015\u103c\u102e\u1038 Table and Data \u101c\u103b\u103e\u1031\u102c\u1000\u103a\u1015\u103c\u102e\u1038\u1015\u102b\u1015\u103c\u102e\u104b Local \u1000 PostgreSQL\u00a0 Server \u1014\u1032\u1037 Visual Studio Code \u1001\u103b\u102d\u1010\u103a\u1015\u102b\u1015\u103c\u102e\u104b \u1019\u1021\u1031\u1038\u1019\u102d\u102f\u1037\u1019\u103e \u1015\u1031\u1038\u101e\u1031\u102c data \u1000\u102d\u102f [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-224","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/posts\/224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/comments?post=224"}],"version-history":[{"count":8,"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/posts\/224\/revisions"}],"predecessor-version":[{"id":256,"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/posts\/224\/revisions\/256"}],"wp:attachment":[{"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/media?parent=224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/categories?post=224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myanmar.ca\/intern\/wp-json\/wp\/v2\/tags?post=224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}