{"id":109432,"date":"2025-05-18T02:18:18","date_gmt":"2025-05-17T22:48:18","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d8%a2%db%8c%d8%a7-%d8%a8%d8%a7%db%8c%d8%af-supabase-auth-%d8%b1%d8%a7-%d8%a8%d8%a7-%d9%be%d8%b1%d9%88%d9%81%d8%a7%db%8c%d9%84-%d9%87%d8%a7%db%8c-%da%a9%d8%a7%d8%b1%d8%a8%d8%b1-%da%af%d8%b3%d8%aa\/"},"modified":"2025-05-18T02:18:18","modified_gmt":"2025-05-17T22:48:18","slug":"%d8%a2%db%8c%d8%a7-%d8%a8%d8%a7%db%8c%d8%af-supabase-auth-%d8%b1%d8%a7-%d8%a8%d8%a7-%d9%be%d8%b1%d9%88%d9%81%d8%a7%db%8c%d9%84-%d9%87%d8%a7%db%8c-%da%a9%d8%a7%d8%b1%d8%a8%d8%b1-%da%af%d8%b3%d8%aa","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d8%a2%db%8c%d8%a7-%d8%a8%d8%a7%db%8c%d8%af-supabase-auth-%d8%b1%d8%a7-%d8%a8%d8%a7-%d9%be%d8%b1%d9%88%d9%81%d8%a7%db%8c%d9%84-%d9%87%d8%a7%db%8c-%da%a9%d8%a7%d8%b1%d8%a8%d8%b1-%da%af%d8%b3%d8%aa\/","title":{"rendered":"\u0622\u06cc\u0627 \u0628\u0627\u06cc\u062f supabase auth \u0631\u0627 \u0628\u0627 \u067e\u0631\u0648\u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u06af\u0633\u062a\u0631\u0634 \u062f\u0647\u06cc\u062f\u061f"},"content":{"rendered":"<div data-article-id=\"2497733\" id=\"article-body\">\n<p>Supabase Auth \u062f\u0631 \u062d\u0627\u0644 \u062d\u0627\u0636\u0631 \u062f\u0627\u0631\u0627\u06cc \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 AUTH \u0627\u0633\u062a. <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fjsmjfigdbbxq5q3fxp1z.png\" alt=\"supabase auth\" loading=\"lazy\" width=\"800\" height=\"567\" title=\"\"><\/p>\n<p>\u062a\u0635\u0648\u06cc\u0631 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0645\u0628\u0647\u0645 \u0628\u0627\u0634\u062f. <\/p>\n<p>\u0627\u06af\u0631 \u062f\u0631 \u062d\u0633\u0627\u0628 Supabase \u062e\u0648\u062f \u0628\u0647 \u067e\u0631\u0648\u0698\u0647 \u0645\u0631\u0627\u062c\u0639\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062c\u062f\u0648\u0644 AUTH \u062e\u0648\u062f \u0631\u0627 \u0627\u0632 \u067e\u0631\u0648\u0698\u0647 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<hr\/>\n<p>\u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0631\u0627 \u0628\u0647 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631 A \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f \u060c \u0627\u062d\u062a\u0645\u0627\u0644\u0627\u064b \u062a\u0639\u062c\u0628 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f <\/p>\n<blockquote>\n<p>\u0622\u06cc\u0627 \u0628\u0627\u06cc\u062f \u062c\u062f\u0648\u0644 \u062e\u0648\u062f \u060c \u067e\u0631\u0648\u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u062c\u062f\u0627\u06af\u0627\u0646\u0647 (\u06cc\u0627 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646) \u062e\u0648\u062f \u0631\u0627 \u062f\u0631 Supabase \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u0648 \u0622\u0646 \u0631\u0627 \u0628\u0627 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 Supabase Auth \u067e\u06cc\u0648\u0646\u062f \u062f\u0647\u06cc\u062f\u061f<\/p>\n<\/blockquote>\n<p><em>\u06cc\u0627<\/em><\/p>\n<blockquote>\n<p>\u0622\u06cc\u0627 \u0628\u0627\u06cc\u062f \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 Supabase Auth \u0631\u0627 \u06af\u0633\u062a\u0631\u0634 \u062f\u0647\u06cc\u062f\u061f<\/p>\n<\/blockquote>\n<hr\/>\n<p>\u0627\u0644\u06af\u0648\u06cc \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc Supabase \u0627\u06cc\u0646 \u0627\u0633\u062a <strong>\u06cc\u06a9 \u062c\u062f\u0648\u0644 \u067e\u0631\u0648\u0641\u0627\u06cc\u0644 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 (\u06cc\u0627 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646) \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/strong> \u062f\u0631 <em>\u0639\u0645\u0648\u0645\u06cc<\/em> \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u0628\u0647 \u062c\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062e\u0644\u06cc <code>auth.users<\/code> \u062c\u062f\u0648\u0644  <\/p>\n<p>\u062f\u0631 <code>auth.users<\/code> \u062c\u062f\u0648\u0644 (\u062f\u0631 <code>auth<\/code> SCHEMA) \u062f\u0631 \u062f\u0627\u062e\u0644 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u0634\u0648\u062f \u0648 \u0627\u0632 \u0637\u0631\u06cc\u0642 API \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u062e\u0648\u062f\u06a9\u0627\u0631 \u062f\u0631 \u0645\u0639\u0631\u0636 \u0622\u0646 \u0642\u0631\u0627\u0631 \u0646\u0645\u06cc \u06af\u06cc\u0631\u062f.  <\/p>\n<p>\u0646\u06af\u0647\u062f\u0627\u0631\u0646\u062f\u0647 \u0647\u0627\u06cc supabase \u0635\u0631\u06cc\u062d\u0627\u064b \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc \u06a9\u0646\u0646\u062f <\/p>\n<blockquote>\n<p><em>&#8220;\u062a\u0648\u0635\u06cc\u0647 \u0646\u0645\u06cc \u0634\u0648\u062f \u06a9\u0647 \u0637\u0631\u062d \u0631\u0627 \u0627\u0635\u0644\u0627\u062d \u06a9\u0646\u06cc\u062f <code>auth.users<\/code>\u061b \u0628\u0647\u062a\u0631\u06cc\u0646 \u0631\u0627\u0647 \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 (\u06cc\u0627 \u067e\u0631\u0648\u0641\u0627\u06cc\u0644) \u062f\u0631 \u0637\u0631\u062d \u0639\u0645\u0648\u0645\u06cc \u0648 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0647\u0631\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u06a9\u0627\u0631\u0628\u0631 \u062f\u0631 \u0622\u0646\u062c\u0627 \u0627\u0633\u062a. &#8220;<\/em><\/p>\n<\/blockquote>\n<hr\/>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/%d8%a2%db%8c%d8%a7-%d8%a8%d8%a7%db%8c%d8%af-supabase-auth-%d8%b1%d8%a7-%d8%a8%d8%a7-%d9%be%d8%b1%d9%88%d9%81%d8%a7%db%8c%d9%84-%d9%87%d8%a7%db%8c-%da%a9%d8%a7%d8%b1%d8%a8%d8%b1-%da%af%d8%b3%d8%aa\/#%D9%BE%DB%8C%D9%88%D9%86%D8%AF_%D9%BE%D8%B1%D9%88%D9%81%D8%A7%DB%8C%D9%84_%D8%A8%D9%87_authusers\" >\u067e\u06cc\u0648\u0646\u062f \u067e\u0631\u0648\u0641\u0627\u06cc\u0644 \u0628\u0647 auth.users<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/%d8%a2%db%8c%d8%a7-%d8%a8%d8%a7%db%8c%d8%af-supabase-auth-%d8%b1%d8%a7-%d8%a8%d8%a7-%d9%be%d8%b1%d9%88%d9%81%d8%a7%db%8c%d9%84-%d9%87%d8%a7%db%8c-%da%a9%d8%a7%d8%b1%d8%a8%d8%b1-%da%af%d8%b3%d8%aa\/#%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D9%BE%D8%B1%D9%88%D9%81%D8%A7%DB%8C%D9%84_%D8%AE%D9%88%D8%AF%DA%A9%D8%A7%D8%B1_%D8%AF%D8%B1_%D8%AB%D8%A8%D8%AA_%D9%86%D8%A7%D9%85\" >\u0627\u06cc\u062c\u0627\u062f \u067e\u0631\u0648\u0641\u0627\u06cc\u0644 \u062e\u0648\u062f\u06a9\u0627\u0631 \u062f\u0631 \u062b\u0628\u062a \u0646\u0627\u0645<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%BE%DB%8C%D9%88%D9%86%D8%AF_%D9%BE%D8%B1%D9%88%D9%81%D8%A7%DB%8C%D9%84_%D8%A8%D9%87_authusers\"><\/span>\n<p>  \u067e\u06cc\u0648\u0646\u062f \u067e\u0631\u0648\u0641\u0627\u06cc\u0644 \u0628\u0647 <code>auth.users<\/code><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062e\u0648\u062f\u062a <code>public.profiles<\/code> (\u06cc\u0627 <code>public.users<\/code>) \u062c\u062f\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <strong>\u0647\u0645\u0627\u0646 uuid \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc<\/strong> \u0648 \u0645\u0631\u062c\u0639 <code>auth.users(id)<\/code><\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Create profiles table<\/span>\n<span class=\"k\">create<\/span> <span class=\"k\">table<\/span> <span class=\"k\">public<\/span><span class=\"p\">.<\/span><span class=\"n\">profiles<\/span> <span class=\"p\">(<\/span>\n  <span class=\"n\">id<\/span> <span class=\"n\">uuid<\/span> <span class=\"k\">primary<\/span> <span class=\"k\">key<\/span> <span class=\"k\">references<\/span> <span class=\"n\">auth<\/span><span class=\"p\">.<\/span><span class=\"n\">users<\/span><span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">)<\/span> <span class=\"k\">on<\/span> <span class=\"k\">delete<\/span> <span class=\"k\">cascade<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">full_name<\/span> <span class=\"nb\">text<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">bio<\/span>       <span class=\"nb\">text<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">avatar_url<\/span> <span class=\"nb\">text<\/span>\n<span class=\"p\">);<\/span>\n\n<span class=\"c1\">-- Enable RLS<\/span>\n<span class=\"k\">alter<\/span> <span class=\"k\">table<\/span> <span class=\"k\">public<\/span><span class=\"p\">.<\/span><span class=\"n\">profiles<\/span> <span class=\"n\">enable<\/span> <span class=\"k\">row<\/span> <span class=\"k\">level<\/span> <span class=\"k\">security<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- Policy for INSERT<\/span>\n<span class=\"k\">create<\/span> <span class=\"n\">policy<\/span> <span class=\"nv\">\"Users can insert own profile\"<\/span>\n<span class=\"k\">on<\/span> <span class=\"k\">public<\/span><span class=\"p\">.<\/span><span class=\"n\">profiles<\/span> <span class=\"k\">for<\/span> <span class=\"k\">insert<\/span>\n<span class=\"k\">with<\/span> <span class=\"k\">check<\/span> <span class=\"p\">(<\/span><span class=\"n\">auth<\/span><span class=\"p\">.<\/span><span class=\"n\">uid<\/span><span class=\"p\">()<\/span> <span class=\"o\">=<\/span> <span class=\"n\">id<\/span><span class=\"p\">);<\/span>\n\n<span class=\"c1\">-- Policy for UPDATE<\/span>\n<span class=\"k\">create<\/span> <span class=\"n\">policy<\/span> <span class=\"nv\">\"Users can update own profile\"<\/span>\n<span class=\"k\">on<\/span> <span class=\"k\">public<\/span><span class=\"p\">.<\/span><span class=\"n\">profiles<\/span> <span class=\"k\">for<\/span> <span class=\"k\">update<\/span>\n<span class=\"k\">using<\/span> <span class=\"p\">(<\/span><span class=\"n\">auth<\/span><span class=\"p\">.<\/span><span class=\"n\">uid<\/span><span class=\"p\">()<\/span> <span class=\"o\">=<\/span> <span class=\"n\">id<\/span><span class=\"p\">);<\/span>\n\n<span class=\"c1\">-- Policy for SELECT<\/span>\n<span class=\"k\">create<\/span> <span class=\"n\">policy<\/span> <span class=\"nv\">\"Users can view own profile\"<\/span>\n<span class=\"k\">on<\/span> <span class=\"k\">public<\/span><span class=\"p\">.<\/span><span class=\"n\">profiles<\/span> <span class=\"k\">for<\/span> <span class=\"k\">select<\/span>\n<span class=\"k\">using<\/span> <span class=\"p\">(<\/span><span class=\"n\">auth<\/span><span class=\"p\">.<\/span><span class=\"n\">uid<\/span><span class=\"p\">()<\/span> <span class=\"o\">=<\/span> <span class=\"n\">id<\/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>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\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<h3><span class=\"ez-toc-section\" id=\"%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D9%BE%D8%B1%D9%88%D9%81%D8%A7%DB%8C%D9%84_%D8%AE%D9%88%D8%AF%DA%A9%D8%A7%D8%B1_%D8%AF%D8%B1_%D8%AB%D8%A8%D8%AA_%D9%86%D8%A7%D9%85\"><\/span>\n<p>  \u0627\u06cc\u062c\u0627\u062f \u067e\u0631\u0648\u0641\u0627\u06cc\u0644 \u062e\u0648\u062f\u06a9\u0627\u0631 \u062f\u0631 \u062b\u0628\u062a \u0646\u0627\u0645<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u062e\u0648\u062f\u06a9\u0627\u0631 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0646\u0645\u0627\u06cc\u0647 \u0647\u0646\u06af\u0627\u0645 \u062b\u0628\u062a \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631 \u062c\u062f\u06cc\u062f (\u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u06cc\u0645\u06cc\u0644 \u06cc\u0627 OAUTH) \u060c \u0627\u0632 A \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <strong>Postgres \u0645\u0627\u0634\u0647<\/strong> \u062f\u0631 <code>auth.users<\/code><\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- 1. Create the function<\/span>\n<span class=\"k\">create<\/span> <span class=\"k\">or<\/span> <span class=\"k\">replace<\/span> <span class=\"k\">function<\/span> <span class=\"k\">public<\/span><span class=\"p\">.<\/span><span class=\"n\">handle_new_user<\/span><span class=\"p\">()<\/span>\n<span class=\"k\">returns<\/span> <span class=\"k\">trigger<\/span>\n<span class=\"k\">language<\/span> <span class=\"n\">plpgsql<\/span> <span class=\"k\">security<\/span> <span class=\"k\">definer<\/span> <span class=\"k\">set<\/span> <span class=\"n\">search_path<\/span> <span class=\"o\">=<\/span> <span class=\"k\">public<\/span>\n<span class=\"k\">as<\/span> <span class=\"err\">$$<\/span>\n<span class=\"k\">begin<\/span>\n  <span class=\"k\">insert<\/span> <span class=\"k\">into<\/span> <span class=\"k\">public<\/span><span class=\"p\">.<\/span><span class=\"n\">profiles<\/span> <span class=\"p\">(<\/span><span class=\"n\">id<\/span><span class=\"p\">)<\/span> <span class=\"k\">values<\/span> <span class=\"p\">(<\/span><span class=\"k\">NEW<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span><span class=\"p\">);<\/span>\n  <span class=\"k\">return<\/span> <span class=\"k\">NEW<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">end<\/span><span class=\"p\">;<\/span>\n<span class=\"err\">$$<\/span><span class=\"p\">;<\/span>\n\n<span class=\"c1\">-- 2. Create the trigger on the Supabase Auth table<\/span>\n<span class=\"k\">create<\/span> <span class=\"k\">trigger<\/span> <span class=\"n\">on_auth_user_created<\/span>\n<span class=\"k\">after<\/span> <span class=\"k\">insert<\/span> <span class=\"k\">on<\/span> <span class=\"n\">auth<\/span><span class=\"p\">.<\/span><span class=\"n\">users<\/span>\n<span class=\"k\">for<\/span> <span class=\"k\">each<\/span> <span class=\"k\">row<\/span> <span class=\"k\">execute<\/span> <span class=\"k\">procedure<\/span> <span class=\"k\">public<\/span><span class=\"p\">.<\/span><span class=\"n\">handle_new_user<\/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>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\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><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Supabase Auth \u062f\u0631 \u062d\u0627\u0644 \u062d\u0627\u0636\u0631 \u062f\u0627\u0631\u0627\u06cc \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 AUTH \u0627\u0633\u062a. \u062a\u0635\u0648\u06cc\u0631 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0645\u0628\u0647\u0645 \u0628\u0627\u0634\u062f. \u0627\u06af\u0631 \u062f\u0631 \u062d\u0633\u0627\u0628 Supabase \u062e\u0648\u062f \u0628\u0647 \u067e\u0631\u0648\u0698\u0647 \u0645\u0631\u0627\u062c\u0639\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062c\u062f\u0648\u0644 AUTH \u062e\u0648\u062f \u0631\u0627 \u0627\u0632 \u067e\u0631\u0648\u0698\u0647 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f. \u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0631\u0627 \u0628\u0647 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631 A \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f \u060c \u0627\u062d\u062a\u0645\u0627\u0644\u0627\u064b \u062a\u0639\u062c\u0628 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f &hellip;<\/p>\n","protected":false},"author":2,"featured_media":109433,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/media2.dev.to\/dynamic\/image\/width=1000,height=500,fit=cover,gravity=auto,format=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F9ob2qkhzq6hoc389cu6m.png","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-109432","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\/109432","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=109432"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/109432\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/109433"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=109432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=109432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=109432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}