[GRASS-dev] db.join useful?

GRASS GRASS developer
1

Hi,

do you consider a db.join script to be useful?

db.join --help

Description:
Allows to join a table into another table.

Keywords:
database, attribute table

Usage:
db.join table=name column=string otable=name ocolumn=string
   [--verbose] [--quiet]

Flags:
--v Verbose module output
--q Quiet module output

Parameters:
    table Table to join into
   column Join column in first table
   otable Other table name
  ocolumn Join column in other table

what it does:
- check for duplicate column names, adds a "b" if found
- adds new column(s) to be joined
- joins (all expect DBF is supported)

?
Markus

2

On Fri, Aug 21, 2009 at 1:07 AM, Markus Neteler<neteler@osgeo.org> wrote:

Hi,

do you consider a db.join script to be useful?

db.join --help

Description:
Allows to join a table into another table.

Keywords:
database, attribute table

Usage:
db.join table=name column=string otable=name ocolumn=string
[--verbose] [--quiet]

For now in Addons. Install with:

g.extension db.join

Markus

3

Hi Markus,

Does your message say that all but DBF back-ends are supported?

Thanks,

Dylan

On Thu, Aug 20, 2009 at 4:07 PM, Markus Neteler<neteler@osgeo.org> wrote:

Hi,

do you consider a db.join script to be useful?

db.join --help

Description:
Allows to join a table into another table.

Keywords:
database, attribute table

Usage:
db.join table=name column=string otable=name ocolumn=string
[--verbose] [--quiet]

Flags:
--v Verbose module output
--q Quiet module output

Parameters:
table Table to join into
column Join column in first table
otable Other table name
ocolumn Join column in other table

what it does:
- check for duplicate column names, adds a "b" if found
- adds new column(s) to be joined
- joins (all expect DBF is supported)

?
Markus
_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev

4

On Fri, Aug 21, 2009 at 5:42 PM, Dylan
Beaudette<dylan.beaudette@gmail.com> wrote:

Hi Markus,

Does your message say that all but DBF back-ends are supported?

Yes - DBF isn't quite SQL capable... same thing as for v.db.join and
other more interesting SQL features.

I usually use SQLite as backend.

Markus