# example for connecting to a PostgreSQL server: db.connect driver=pg database="host=myserver.itc.it,dbname=mydb" db.login user=myname pass=secret db.connect -p db.tables -p
echo " ALTER TABLE mytable ADD ID integer; CREATE SEQUENCE mytable_seq; UPDATE mytabe SET ID = nextval('mytable_seq'); DROP SEQUENCE mytable_seq; " | db.execute
\h copy COPY t1 FROM 'filename' USING DELIMITERS ',';
Book: PostgreSQL:
Introduction and Concepts by Bruce Momjian
PostgreSQL Documentation
PostgreSQL Technical Documentation
GDAL/OGR PostgreSQL driver documentation
MapServer Wiki
Last changed: $Date$