database(1grass) Grass User's Manual database(1grass)GRASS GIS 6.4.2 Reference Manual
Geographic Resources Analysis Support System, commonly referred to as GRASS, is a <a href="http://en.wikipedia.org/wiki/Geographic_informa-
tion_system">Geographic Information System (GIS) used for geospatial data management and analysis, image processing, graphics/maps produc-
tion, spatial modeling, and visualization. GRASS is currently used in academic and commercial settings around the world, as well as by many
governmental agencies and environmental consulting companies.
This reference manual details the use of modules distributed with Geographic Resources Analysis Support System (GRASS), an open source (GNU
GPL'ed), image processing and geographic information system (GIS). Go back to help overview
database commands:
| db.columns | List all columns for a given table.
| db.connect | Prints/sets general DB connection for current mapset and exits.
| db.copy | Copy a table.
| db.describe | Describes a table in detail.
| db.drivers | Lists all database drivers.
| db.dropcol | Drops a column from selected attribute table
| db.droptable | Drops an attribute table.
| db.execute | Executes any SQL statement.
| db.in.ogr | Imports attribute tables in various formats.
| db.login | Sets user/password for driver/database.
| db.out.ogr | Exports attribute tables into various formats.
| db.select | Selects data from attribute table (performs SQL query statement(s)).
| db.tables | Lists all tables for a given database.
| db.test | Test database driver, database must exist and set by db.connect.
Full Index
(C) 2003-2011 GRASS Development Team
GRASS 6.4.2database(1grass)
Check Out this Related Man Page
database(1grass) Grass User's Manual database(1grass)GRASS GIS 6.4.2 Reference Manual
Geographic Resources Analysis Support System, commonly referred to as GRASS, is a <a href="http://en.wikipedia.org/wiki/Geographic_informa-
tion_system">Geographic Information System (GIS) used for geospatial data management and analysis, image processing, graphics/maps produc-
tion, spatial modeling, and visualization. GRASS is currently used in academic and commercial settings around the world, as well as by many
governmental agencies and environmental consulting companies.
This reference manual details the use of modules distributed with Geographic Resources Analysis Support System (GRASS), an open source (GNU
GPL'ed), image processing and geographic information system (GIS). Go back to help overview
database commands:
| db.columns | List all columns for a given table.
| db.connect | Prints/sets general DB connection for current mapset and exits.
| db.copy | Copy a table.
| db.describe | Describes a table in detail.
| db.drivers | Lists all database drivers.
| db.dropcol | Drops a column from selected attribute table
| db.droptable | Drops an attribute table.
| db.execute | Executes any SQL statement.
| db.in.ogr | Imports attribute tables in various formats.
| db.login | Sets user/password for driver/database.
| db.out.ogr | Exports attribute tables into various formats.
| db.select | Selects data from attribute table (performs SQL query statement(s)).
| db.tables | Lists all tables for a given database.
| db.test | Test database driver, database must exist and set by db.connect.
Full Index
(C) 2003-2011 GRASS Development Team
GRASS 6.4.2database(1grass)
Hi
I have some 200 tables and I have macro which actually returns the tables columns descriptions . Say for exapmle describe('table1') will list all the columns of table one with the description.
Now what I want to do is I want to write a shell script which will take tables name from a file... (1 Reply)
I have to read one input file which will give me some tables info like TradeNo,MsgId,status etc...
I have read that TradeNo from that input file and then look for that trade no in the database table and in the database I have to update the columns for that particular trade which I am getting fron... (7 Replies)
hi gurus,
I am having a file containing a list of tables.i want to find the count of records inside thes tables.
for this i have to connect into database and i have to put the count for all the tables inside another file i used the following loop once all the tablenames are inside the file.
... (1 Reply)
HI All,
Newbie here.
I have a script which generates the tables in teradata database with time stamp like below.I want to add some more code to delete the archive tables which are 2months old.
. $HOME/.profile
t_name=$1
procdate=`date +%y%m%d`
log_dir=$Folder/log
tab=`echo... (0 Replies)
I'm pretty new to the database world and I've run into a mental block of sorts. I've been unable to find the answer anywhere. Here's my problem: I have several tables and everything is as normalized as possible (as I've been lead to understand normalization.) Normalization has lead to some... (1 Reply)
I want to connect to oracle database from solaris...
After that i will drop and create a no.of tables.One of the table example is as below.
sqlplus -s usrname/password@dbname << SQL >> $logfile 2>&1
echo " dropping the table1" | tee logfile
DROP TABLE Table1
echo "creating the table1" |... (1 Reply)
Hi,
I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script.
The table has two columns - Acct_number (not nullable) and date (timestamp).
I'm not able to write a shell script for that. Can any one help me?
... (3 Replies)
dear all
please help me !
i need a script for exporting the selected tables of oracle database installed on CentOs.
i waiting your response.
thanks and regards (6 Replies)
Hi All.
Does anybody here know the System I database? it's from IBM. because i don't know how to connect on the database using unix. How do i know what parameter will i use?
Thanks, (2 Replies)