zhang zhe wrote:
Hello,
Thanks. Actually, I have windows and apache server installed in my
computer. In this case how the code should look like?
What´s the mylinuxserver ? is it the IP adress of the server? or name of
the server?
Will my code changed into
psql.exe -h mywindowsServer -d postgres -U zhe -f c:/users/sqlfile.sql
You can, but I would highly recommend that you read the psql.exe
documentation at
http://www.postgresql.org/docs/9.0/interactive/app-psql.html which
should answer all your questions.
In particular, the postgres database is an in-built database designed
for maintenance and shouldn't be used to store user data.
Can I write this code to php?
Indeed - you'll need to look at the exec() function. Don't forget to
escape your shell characters for security.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users