# example for connecting to a PostgreSQL server: db.connect driver=pg database=mydb db.login user=myname password=secret host=myserver.osgeo.org # port=5432 db.connect -p db.tables -p
The file .pgpass in a user's home directory can contain passwords to be used if the connection requires a password (and no password has been specified otherwise). On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). Alternatively, a password file can be specified using the connection parameter passfile or the environment variable PGPASSFILE. This file should contain lines of the following format:
hostname:port:database:username:password
db.execute sql="ALTER TABLE mytable ADD ID integer" db.execute sql="CREATE SEQUENCE mytable_seq" db.execute sql="UPDATE mytable SET ID = nextval('mytable_seq')" db.execute sql="DROP SEQUENCE mytable_seq"
\h copy COPY t1 FROM 'filename' USING DELIMITERS ',';
CREATE TABLE test ( id serial NOT NULL, mytime timestamp DEFAULT now(), text varchar, wkb_geometry geometry, CONSTRAINT test_pkey PRIMARY KEY (id) ) WITHOUT OIDS; # insert value INSERT INTO test (text, wkb_geometry) VALUES ('Name',geometryFromText('POLYGON((600000 200000,650000 200000,650000 250000,600000 250000,600000 200000))',-1)); # register geometry column select AddGeometryColumn ('postgis', 'test', 'geometry', -1, 'GEOMETRY', 2);
v.in.ogr input="PG:host=localhost dbname=postgis user=neteler" layer=test \ output=test type=boundary,centroid v.db.select test v.info -t test
Database management in GRASS GIS
Help pages for database modules
SQL support in GRASS GIS
Available at: PostgreSQL DATABASE DRIVER source code (history)
Latest change: Wednesday Nov 27 22:53:26 2024 in commit: 3b5486c0463a7103ab2109e28bf860fe34539868
Main index | Topics index | Keywords index | Graphical index | Full index
© 2003-2024 GRASS Development Team, GRASS GIS 8.5.0dev Reference Manual