[ADMIN] how to use PostGIS with Postgres

2006-02-23 Thread Yantao Shi
We have PostGIS 1.1.1 installed and I am trying to get it to work with Postgres8.1.1 on our system. Could some one give me a small sample script that lets me connect to postgis from Postgres? I have never used postgis before. I need to test its geo-spatial functionality with Postgres. Tha

Re: [ADMIN] psql copy script

2006-01-25 Thread Yantao Shi
Don't you have to use a "\" in front of copy like : \copy? I use \copy command all the time, never have any problems with it. Yantao Shi [EMAIL PROTECTED] wrote: Hi Alvaro Thanks for the help but it does not work. when I execute it than I get: [test/data] su - postgres -c