PostgreSQL

From A2Wiki

Jump to: navigation, search

Adding ltree support to a database

For working with hierarchical data. See http://www.sai.msu.su/~megera/postgres/gist/ltree/ for more information.

Via SSH session, do:

 psql -U user_name database_name < /usr/share/pgsql/contrib/ltree.sql

where user_name is your PostgreSQL database username (created in cPanel and added to the database) and database_name is the PostgreSQL database name (also created in cPanel).

Personal tools