I am having trouble resolving the pth to use to run the script. Here are the results of "exec locate ltree.sql":
-------------------------------------------------------------
/usr/local/src/postgresql-7.4.6/contrib/ltree/ltree.sql.in
/usr/local/src/postgresql-7.4.6/contrib/ltree/sql/ltree.sql
/usr/local/src/postgresql-8.2.1/contrib/ltree/ltree.sql.in
/usr/local/src/postgresql-8.2.1/contrib/ltree/uninstall_ltree.sql
/usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql
/usr/local/src/postgresql-8.2.1-pre-upgrade/contrib/ltree/ltree.sql.in
/usr/local/src/postgresql-8.2.1-pre-upgrade/contrib/ltree/uninstall_ltree.sql
/usr/local/src/postgresql-8.2.1-pre-upgrade/contrib/ltree/sql/ltree.sql
-------------------------------------------------------------
I assume I want to run this one:
/usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql
I have tired the following but just get and error:
exec psql </usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql>
exec psql<ltree.sql>
exec psql<./usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql>
I am not really sure of the directory structure I am accessing so don't know how to resolve it.
Thank you.
