Skip to content

Instantly share code, notes, and snippets.

@vladmiller
Created June 12, 2015 11:16
Show Gist options
  • Save vladmiller/2a317be406613ec8ee2a to your computer and use it in GitHub Desktop.
Save vladmiller/2a317be406613ec8ee2a to your computer and use it in GitHub Desktop.
List of Language Code for Postgresql
INSERT INTO public.language("code", "name", "nativename") VALUES ('ab', 'Abkhaz', 'аҧсуа');
INSERT INTO public.language("code", "name", "nativename") VALUES ('aa', 'Afar', 'Afaraf');
INSERT INTO public.language("code", "name", "nativename") VALUES ('af', 'Afrikaans', 'Afrikaans');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ak', 'Akan', 'Akan');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sq', 'Albanian', 'Shqip');
INSERT INTO public.language("code", "name", "nativename") VALUES ('am', 'Amharic', 'አማርኛ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ar', 'Arabic', 'العربية');
INSERT INTO public.language("code", "name", "nativename") VALUES ('an', 'Aragonese', 'Aragonés');
INSERT INTO public.language("code", "name", "nativename") VALUES ('hy', 'Armenian', 'Հայերեն');
INSERT INTO public.language("code", "name", "nativename") VALUES ('as', 'Assamese', 'অসমীয়া');
INSERT INTO public.language("code", "name", "nativename") VALUES ('av', 'Avaric', 'авар мацӀ, магӀарул мацӀ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ae', 'Avestan', 'avesta');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ay', 'Aymara', 'aymar aru');
INSERT INTO public.language("code", "name", "nativename") VALUES ('az', 'Azerbaijani', 'azərbaycan dili');
INSERT INTO public.language("code", "name", "nativename") VALUES ('bm', 'Bambara', 'bamanankan');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ba', 'Bashkir', 'башҡорт теле');
INSERT INTO public.language("code", "name", "nativename") VALUES ('eu', 'Basque', 'euskara, euskera');
INSERT INTO public.language("code", "name", "nativename") VALUES ('be', 'Belarusian', 'Беларуская');
INSERT INTO public.language("code", "name", "nativename") VALUES ('bn', 'Bengali', 'বাংলা');
INSERT INTO public.language("code", "name", "nativename") VALUES ('bh', 'Bihari', 'भोजपुरी');
INSERT INTO public.language("code", "name", "nativename") VALUES ('bi', 'Bislama', 'Bislama');
INSERT INTO public.language("code", "name", "nativename") VALUES ('bs', 'Bosnian', 'bosanski jezik');
INSERT INTO public.language("code", "name", "nativename") VALUES ('br', 'Breton', 'brezhoneg');
INSERT INTO public.language("code", "name", "nativename") VALUES ('bg', 'Bulgarian', 'български език');
INSERT INTO public.language("code", "name", "nativename") VALUES ('my', 'Burmese', 'ဗမာစာ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ca', 'Catalan; Valencian', 'Català');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ch', 'Chamorro', 'Chamoru');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ce', 'Chechen', 'нохчийн мотт');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ny', 'Chichewa; Chewa; Nyanja', 'chiCheŵa, chinyanja');
INSERT INTO public.language("code", "name", "nativename") VALUES ('zh', 'Chinese', '中文 (Zhōngwén), 汉语, 漢語');
INSERT INTO public.language("code", "name", "nativename") VALUES ('cv', 'Chuvash', 'чӑваш чӗлхи');
INSERT INTO public.language("code", "name", "nativename") VALUES ('kw', 'Cornish', 'Kernewek');
INSERT INTO public.language("code", "name", "nativename") VALUES ('co', 'Corsican', 'corsu, lingua corsa');
INSERT INTO public.language("code", "name", "nativename") VALUES ('cr', 'Cree', 'ᓀᐦᐃᔭᐍᐏᐣ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('hr', 'Croatian', 'hrvatski');
INSERT INTO public.language("code", "name", "nativename") VALUES ('cs', 'Czech', 'česky, čeština');
INSERT INTO public.language("code", "name", "nativename") VALUES ('da', 'Danish', 'dansk');
INSERT INTO public.language("code", "name", "nativename") VALUES ('dv', 'Divehi; Dhivehi; Maldivian;', 'ދިވެހި');
INSERT INTO public.language("code", "name", "nativename") VALUES ('nl', 'Dutch', 'Nederlands, Vlaams');
INSERT INTO public.language("code", "name", "nativename") VALUES ('en', 'English', 'English');
INSERT INTO public.language("code", "name", "nativename") VALUES ('eo', 'Esperanto', 'Esperanto');
INSERT INTO public.language("code", "name", "nativename") VALUES ('et', 'Estonian', 'eesti, eesti keel');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ee', 'Ewe', 'Eʋegbe');
INSERT INTO public.language("code", "name", "nativename") VALUES ('fo', 'Faroese', 'føroyskt');
INSERT INTO public.language("code", "name", "nativename") VALUES ('fj', 'Fijian', 'vosa Vakaviti');
INSERT INTO public.language("code", "name", "nativename") VALUES ('fi', 'Finnish', 'suomi, suomen kieli');
INSERT INTO public.language("code", "name", "nativename") VALUES ('fr', 'French', 'français, langue française');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ff', 'Fula; Fulah; Pulaar; Pular', 'Fulfulde, Pulaar, Pular');
INSERT INTO public.language("code", "name", "nativename") VALUES ('gl', 'Galician', 'Galego');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ka', 'Georgian', 'ქართული');
INSERT INTO public.language("code", "name", "nativename") VALUES ('de', 'German', 'Deutsch');
INSERT INTO public.language("code", "name", "nativename") VALUES ('el', 'Greek, Modern', 'Ελληνικά');
INSERT INTO public.language("code", "name", "nativename") VALUES ('gn', 'Guaraní', 'Avañeẽ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('gu', 'Gujarati', 'ગુજરાતી');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ht', 'Haitian; Haitian Creole', 'Kreyòl ayisyen');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ha', 'Hausa', 'Hausa, هَوُسَ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('he', 'Hebrew (modern)', 'עברית');
INSERT INTO public.language("code", "name", "nativename") VALUES ('hz', 'Herero', 'Otjiherero');
INSERT INTO public.language("code", "name", "nativename") VALUES ('hi', 'Hindi', 'हिन्दी, हिंदी');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ho', 'Hiri Motu', 'Hiri Motu');
INSERT INTO public.language("code", "name", "nativename") VALUES ('hu', 'Hungarian', 'Magyar');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ia', 'Interlingua', 'Interlingua');
INSERT INTO public.language("code", "name", "nativename") VALUES ('id', 'Indonesian', 'Bahasa Indonesia');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ie', 'Interlingue', 'Originally called Occidental; then Interlingue after WWII');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ga', 'Irish', 'Gaeilge');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ig', 'Igbo', 'Asụsụ Igbo');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ik', 'Inupiaq', 'Iñupiaq, Iñupiatun');
INSERT INTO public.language("code", "name", "nativename") VALUES ('io', 'Ido', 'Ido');
INSERT INTO public.language("code", "name", "nativename") VALUES ('is', 'Icelandic', 'Íslenska');
INSERT INTO public.language("code", "name", "nativename") VALUES ('it', 'Italian', 'Italiano');
INSERT INTO public.language("code", "name", "nativename") VALUES ('iu', 'Inuktitut', 'ᐃᓄᒃᑎᑐᑦ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ja', 'Japanese', '日本語 (にほんご/にっぽんご)');
INSERT INTO public.language("code", "name", "nativename") VALUES ('jv', 'Javanese', 'basa Jawa');
INSERT INTO public.language("code", "name", "nativename") VALUES ('kl', 'Kalaallisut, Greenlandic', 'kalaallisut, kalaallit oqaasii');
INSERT INTO public.language("code", "name", "nativename") VALUES ('kn', 'Kannada', 'ಕನ್ನಡ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('kr', 'Kanuri', 'Kanuri');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ks', 'Kashmiri', 'कश्मीरी, كشميري‎');
INSERT INTO public.language("code", "name", "nativename") VALUES ('kk', 'Kazakh', 'Қазақ тілі');
INSERT INTO public.language("code", "name", "nativename") VALUES ('km', 'Khmer', 'ភាសាខ្មែរ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ki', 'Kikuyu, Gikuyu', 'Gĩkũyũ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('rw', 'Kinyarwanda', 'Ikinyarwanda');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ky', 'Kirghiz, Kyrgyz', 'кыргыз тили');
INSERT INTO public.language("code", "name", "nativename") VALUES ('kv', 'Komi', 'коми кыв');
INSERT INTO public.language("code", "name", "nativename") VALUES ('kg', 'Kongo', 'KiKongo');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ko', 'Korean', '한국어 (韓國語), 조선말 (朝鮮語)');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ku', 'Kurdish', 'Kurdî, كوردی‎');
INSERT INTO public.language("code", "name", "nativename") VALUES ('kj', 'Kwanyama, Kuanyama', 'Kuanyama');
INSERT INTO public.language("code", "name", "nativename") VALUES ('la', 'Latin', 'latine, lingua latina');
INSERT INTO public.language("code", "name", "nativename") VALUES ('lb', 'Luxembourgish, Letzeburgesch', 'Lëtzebuergesch');
INSERT INTO public.language("code", "name", "nativename") VALUES ('lg', 'Luganda', 'Luganda');
INSERT INTO public.language("code", "name", "nativename") VALUES ('li', 'Limburgish, Limburgan, Limburger', 'Limburgs');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ln', 'Lingala', 'Lingála');
INSERT INTO public.language("code", "name", "nativename") VALUES ('lo', 'Lao', 'ພາສາລາວ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('lt', 'Lithuanian', 'lietuvių kalba');
INSERT INTO public.language("code", "name", "nativename") VALUES ('lu', 'Luba-Katanga', '');
INSERT INTO public.language("code", "name", "nativename") VALUES ('lv', 'Latvian', 'latviešu valoda');
INSERT INTO public.language("code", "name", "nativename") VALUES ('gv', 'Manx', 'Gaelg, Gailck');
INSERT INTO public.language("code", "name", "nativename") VALUES ('mk', 'Macedonian', 'македонски јазик');
INSERT INTO public.language("code", "name", "nativename") VALUES ('mg', 'Malagasy', 'Malagasy fiteny');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ms', 'Malay', 'bahasa Melayu, بهاس ملايو‎');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ml', 'Malayalam', 'മലയാളം');
INSERT INTO public.language("code", "name", "nativename") VALUES ('mt', 'Maltese', 'Malti');
INSERT INTO public.language("code", "name", "nativename") VALUES ('mi', 'Māori', 'te reo Māori');
INSERT INTO public.language("code", "name", "nativename") VALUES ('mr', 'Marathi (Marāṭhī)', 'मराठी');
INSERT INTO public.language("code", "name", "nativename") VALUES ('mh', 'Marshallese', 'Kajin M̧ajeļ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('mn', 'Mongolian', 'монгол');
INSERT INTO public.language("code", "name", "nativename") VALUES ('na', 'Nauru', 'Ekakairũ Naoero');
INSERT INTO public.language("code", "name", "nativename") VALUES ('nv', 'Navajo, Navaho', 'Diné bizaad, Dinékʼehǰí');
INSERT INTO public.language("code", "name", "nativename") VALUES ('nb', 'Norwegian Bokmål', 'Norsk bokmål');
INSERT INTO public.language("code", "name", "nativename") VALUES ('nd', 'North Ndebele', 'isiNdebele');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ne', 'Nepali', 'नेपाली');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ng', 'Ndonga', 'Owambo');
INSERT INTO public.language("code", "name", "nativename") VALUES ('nn', 'Norwegian Nynorsk', 'Norsk nynorsk');
INSERT INTO public.language("code", "name", "nativename") VALUES ('no', 'Norwegian', 'Norsk');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ii', 'Nuosu', 'ꆈꌠ꒿ Nuosuhxop');
INSERT INTO public.language("code", "name", "nativename") VALUES ('nr', 'South Ndebele', 'isiNdebele');
INSERT INTO public.language("code", "name", "nativename") VALUES ('oc', 'Occitan', 'Occitan');
INSERT INTO public.language("code", "name", "nativename") VALUES ('oj', 'Ojibwe, Ojibwa', 'ᐊᓂᔑᓈᐯᒧᐎᓐ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('cu', 'Old Church Slavonic, Church Slavic, Church Slavonic, Old Bulgarian, Old Slavonic', 'ѩзыкъ словѣньскъ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('om', 'Oromo', 'Afaan Oromoo');
INSERT INTO public.language("code", "name", "nativename") VALUES ('or', 'Oriya', 'ଓଡ଼ିଆ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('os', 'Ossetian, Ossetic', 'ирон æвзаг');
INSERT INTO public.language("code", "name", "nativename") VALUES ('pa', 'Panjabi, Punjabi', 'ਪੰਜਾਬੀ, پنجابی‎');
INSERT INTO public.language("code", "name", "nativename") VALUES ('pi', 'Pāli', 'पाऴि');
INSERT INTO public.language("code", "name", "nativename") VALUES ('fa', 'Persian', 'فارسی');
INSERT INTO public.language("code", "name", "nativename") VALUES ('pl', 'Polish', 'polski');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ps', 'Pashto, Pushto', 'پښتو');
INSERT INTO public.language("code", "name", "nativename") VALUES ('pt', 'Portuguese', 'Português');
INSERT INTO public.language("code", "name", "nativename") VALUES ('qu', 'Quechua', 'Runa Simi, Kichwa');
INSERT INTO public.language("code", "name", "nativename") VALUES ('rm', 'Romansh', 'rumantsch grischun');
INSERT INTO public.language("code", "name", "nativename") VALUES ('rn', 'Kirundi', 'kiRundi');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ro', 'Romanian, Moldavian, Moldovan', 'română');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ru', 'Russian', 'русский язык');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sa', 'Sanskrit (Saṁskṛta)', 'संस्कृतम्');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sc', 'Sardinian', 'sardu');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sd', 'Sindhi', 'सिन्धी, سنڌي، سندھی‎');
INSERT INTO public.language("code", "name", "nativename") VALUES ('se', 'Northern Sami', 'Davvisámegiella');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sm', 'Samoan', 'gagana faa Samoa');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sg', 'Sango', 'yângâ tî sängö');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sr', 'Serbian', 'српски језик');
INSERT INTO public.language("code", "name", "nativename") VALUES ('gd', 'Scottish Gaelic; Gaelic', 'Gàidhlig');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sn', 'Shona', 'chiShona');
INSERT INTO public.language("code", "name", "nativename") VALUES ('si', 'Sinhala, Sinhalese', 'සිංහල');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sk', 'Slovak', 'slovenčina');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sl', 'Slovene', 'slovenščina');
INSERT INTO public.language("code", "name", "nativename") VALUES ('so', 'Somali', 'Soomaaliga, af Soomaali');
INSERT INTO public.language("code", "name", "nativename") VALUES ('st', 'Southern Sotho', 'Sesotho');
INSERT INTO public.language("code", "name", "nativename") VALUES ('es', 'Spanish; Castilian', 'español, castellano');
INSERT INTO public.language("code", "name", "nativename") VALUES ('su', 'Sundanese', 'Basa Sunda');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sw', 'Swahili', 'Kiswahili');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ss', 'Swati', 'SiSwati');
INSERT INTO public.language("code", "name", "nativename") VALUES ('sv', 'Swedish', 'svenska');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ta', 'Tamil', 'தமிழ்');
INSERT INTO public.language("code", "name", "nativename") VALUES ('te', 'Telugu', 'తెలుగు');
INSERT INTO public.language("code", "name", "nativename") VALUES ('tg', 'Tajik', 'тоҷикӣ, toğikī, تاجیکی‎');
INSERT INTO public.language("code", "name", "nativename") VALUES ('th', 'Thai', 'ไทย');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ti', 'Tigrinya', 'ትግርኛ');
INSERT INTO public.language("code", "name", "nativename") VALUES ('bo', 'Tibetan Standard, Tibetan, Central', 'བོད་ཡིག');
INSERT INTO public.language("code", "name", "nativename") VALUES ('tk', 'Turkmen', 'Türkmen, Түркмен');
INSERT INTO public.language("code", "name", "nativename") VALUES ('tn', 'Tswana', 'Setswana');
INSERT INTO public.language("code", "name", "nativename") VALUES ('to', 'Tonga (Tonga Islands)', 'faka Tonga');
INSERT INTO public.language("code", "name", "nativename") VALUES ('tr', 'Turkish', 'Türkçe');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ts', 'Tsonga', 'Xitsonga');
INSERT INTO public.language("code", "name", "nativename") VALUES ('tt', 'Tatar', 'татарча, tatarça, تاتارچا‎');
INSERT INTO public.language("code", "name", "nativename") VALUES ('tw', 'Twi', 'Twi');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ty', 'Tahitian', 'Reo Tahiti');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ug', 'Uighur, Uyghur', 'Uyƣurqə, ئۇيغۇرچە‎');
INSERT INTO public.language("code", "name", "nativename") VALUES ('uk', 'Ukrainian', 'українська');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ur', 'Urdu', 'اردو');
INSERT INTO public.language("code", "name", "nativename") VALUES ('uz', 'Uzbek', 'zbek, Ўзбек, أۇزبېك‎');
INSERT INTO public.language("code", "name", "nativename") VALUES ('ve', 'Venda', 'Tshivenḓa');
INSERT INTO public.language("code", "name", "nativename") VALUES ('vi', 'Vietnamese', 'Tiếng Việt');
INSERT INTO public.language("code", "name", "nativename") VALUES ('vo', 'Volapük', 'Volapük');
INSERT INTO public.language("code", "name", "nativename") VALUES ('wa', 'Walloon', 'Walon');
INSERT INTO public.language("code", "name", "nativename") VALUES ('cy', 'Welsh', 'Cymraeg');
INSERT INTO public.language("code", "name", "nativename") VALUES ('wo', 'Wolof', 'Wollof');
INSERT INTO public.language("code", "name", "nativename") VALUES ('fy', 'Western Frisian', 'Frysk');
INSERT INTO public.language("code", "name", "nativename") VALUES ('xh', 'Xhosa', 'isiXhosa');
INSERT INTO public.language("code", "name", "nativename") VALUES ('yi', 'Yiddish', 'ייִדיש');
INSERT INTO public.language("code", "name", "nativename") VALUES ('yo', 'Yoruba', 'Yorùbá');
INSERT INTO public.language("code", "name", "nativename") VALUES ('za', 'Zhuang, Chuang', 'Saɯ cueŋƅ, Saw cuengh');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment