Difference between revisions of "Adding an extension in PostgreSQL"
⧼vector-jumptonavigation⧽
⧼vector-jumptosearch⧽
Ccunha64415 (talk | contribs) |
|||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | <span data-link_translate_ro_title="Adăugarea unei extensii în PostgreSQL" data-link_translate_ro_url="Adăugarea unei extensii în PostgreSQL"></span>[[:ro:Adăugarea unei extensii în PostgreSQL]][[ro:Adăugarea unei extensii în PostgreSQL]] | ||
| + | <span data-link_translate_ru_title="Добавление расширения в PostgreSQL" data-link_translate_ru_url="Добавление расширения в PostgreSQL"></span>[[:ru:Добавление расширения в PostgreSQL]][[ru:Добавление расширения в PostgreSQL]] | ||
| + | <span data-link_translate_pl_title="Dodawanie rozszerzeń w PostgreSQL" data-link_translate_pl_url="Dodawanie rozszerzeń w PostgreSQL"></span>[[:pl:Dodawanie rozszerzeń w PostgreSQL]][[pl:Dodawanie rozszerzeń w PostgreSQL]] | ||
| + | <span data-link_translate_ja_title="PostgreSQLでの拡張機能の追加" data-link_translate_ja_url="PostgreSQLでの拡張機能の追加"></span>[[:ja:PostgreSQLでの拡張機能の追加]][[ja:PostgreSQLでの拡張機能の追加]] | ||
| + | <span data-link_translate_zh_title="在PostgreSQL中添加一个扩展" data-link_translate_zh_url="在PostgreSQL中添加一个扩展"></span>[[:zh:在PostgreSQL中添加一个扩展]][[zh:在PostgreSQL中添加一个扩展]] | ||
| + | <span data-link_translate_de_title="Hinzufügen einer Erweiterung in PostgreSQL" data-link_translate_de_url="Hinzufügen einer Erweiterung in PostgreSQL"></span>[[:de:Hinzufügen einer Erweiterung in PostgreSQL]][[de:Hinzufügen einer Erweiterung in PostgreSQL]] | ||
<span data-link_translate_nl_title="Een extensie toevoegen in PostgreSQL" data-link_translate_nl_url="Een extensie toevoegen in PostgreSQL"></span>[[:nl:Een extensie toevoegen in PostgreSQL]][[nl:Een extensie toevoegen in PostgreSQL]] | <span data-link_translate_nl_title="Een extensie toevoegen in PostgreSQL" data-link_translate_nl_url="Een extensie toevoegen in PostgreSQL"></span>[[:nl:Een extensie toevoegen in PostgreSQL]][[nl:Een extensie toevoegen in PostgreSQL]] | ||
<span data-link_translate_it_title="Aggiungere un'estensione in PostgreSQL" data-link_translate_it_url="Aggiungere un'estensione in PostgreSQL"></span>[[:it:Aggiungere un'estensione in PostgreSQL]][[it:Aggiungere un'estensione in PostgreSQL]] | <span data-link_translate_it_title="Aggiungere un'estensione in PostgreSQL" data-link_translate_it_url="Aggiungere un'estensione in PostgreSQL"></span>[[:it:Aggiungere un'estensione in PostgreSQL]][[it:Aggiungere un'estensione in PostgreSQL]] | ||
| Line 17: | Line 23: | ||
==Introduction== | ==Introduction== | ||
| − | This page deals with adding an extension to a PostgreSQL database. | + | This page deals with adding an extension to a [https://www.ikoula.com/en/public-cloud/oneclick/postgresql PostgreSQL] database. |
==Connecting to PostgreSQL== | ==Connecting to PostgreSQL== | ||
| Line 81: | Line 87: | ||
<!-- Placez ci-dessous la ou les catégories auxquelles se rapporte votre article. Ex: [[Category:Contribute]] [[Category:Linux]] --> | <!-- Placez ci-dessous la ou les catégories auxquelles se rapporte votre article. Ex: [[Category:Contribute]] [[Category:Linux]] --> | ||
| − | + | [[Category:Linux]] | |
[[Category:VPS server]] | [[Category:VPS server]] | ||
[[Category:Dedicated server]] | [[Category:Dedicated server]] | ||
Latest revision as of 15:57, 23 January 2022
ro:Adăugarea unei extensii în PostgreSQL
ru:Добавление расширения в PostgreSQL
pl:Dodawanie rozszerzeń w PostgreSQL
ja:PostgreSQLでの拡張機能の追加
zh:在PostgreSQL中添加一个扩展
de:Hinzufügen einer Erweiterung in PostgreSQL
nl:Een extensie toevoegen in PostgreSQL
it:Aggiungere un'estensione in PostgreSQL
pt:Acrescentar uma extensão no PostgreSQL
es:Añadir una extensión en PostgreSQL
fr:Ajouter une extension en PostgreSQL
This article has been created by an automatic translation software. You can view the article source here.
Introduction
This page deals with adding an extension to a PostgreSQL database.
Connecting to PostgreSQL
We switch to the postgres user and then connect to the PostgreSQL database test:
# su - postgres
postgres@vm-postgres:~$ psql -d test
psql (9.1.24lts2)
Saisissez « help » pour l aide.
test=#
We check the extensions currently present:
test=# \dx
Liste des extensions installées
Nom | Version | Schéma | Description
-----------+---------+------------+-------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 ligne)
Adding an extension
We will, for example, add the extension unaccent (a function that allows, among other things, to remove accents):
test=# CREATE EXTENSION IF NOT EXISTS "unaccent";
CREATE EXTENSION
We check that it is in place:
test=# \dx
Liste des extensions installées
Nom | Version | Schéma | Description
-----------+---------+------------+-------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
unaccent | 1.0 | public | text search dictionary that removes accents
(2 lignes)
We can also check that it is functional, for example:
test=# SELECT unaccent('Hôtel');
unaccent
----------
Hotel
(1 ligne)
The word Hotel is returned without a circumflex accent.
Cet article vous a semblé utile ?
0
Enable comment auto-refresher