v.db.addcolumn.html 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <h2>DESCRIPTION</h2>
  2. <em>v.db.addcolumn</em> adds one or more column(s) to the attribute table
  3. connected to a given vector map. It automatically checks the connection for the
  4. specified layer.
  5. <h2>NOTES</h2>
  6. <em>v.db.addcolumn</em> is a front-end to <em>db.execute</em> to allow easier usage.
  7. The supported types of columns depend on the database backend. However, all
  8. backends should support VARCHAR, INT, DOUBLE PRECISION and DATE.
  9. <p>The existing database connection(s) can be verified with <em>v.db.connect</em>.
  10. <h2>EXAMPLES</h2>
  11. Adding a single column:<br>
  12. <div class="code"><pre>
  13. g.copy vect=roadsmajor,myroads
  14. v.db.addcolumn myroads columns="slope double precision"
  15. v.info -c myroads
  16. </pre></div>
  17. <p>Adding two columns:<br>
  18. <div class="code"><pre>
  19. g.copy vect=roadsmajor,myroads
  20. v.db.addcolumn myroads columns="slope double precision,myname varchar(15)"
  21. v.info -c myroads
  22. </pre></div>
  23. <h2>SEE ALSO</h2>
  24. <em>
  25. <a href="db.connect.html">db.connect</a>,
  26. <a href="db.execute.html">db.execute</a>,
  27. <a href="v.db.addtable.html">v.db.addtable</a>,
  28. <a href="v.db.connect.html">v.db.connect</a>,
  29. <a href="v.db.dropcolumn.html">v.db.dropcolumn</a>,
  30. <a href="v.db.droptable.html">v.db.droptable</a>,
  31. <a href="v.db.select.html">v.db.select</a>,
  32. <a href="v.db.update.html">v.db.update</a><br>
  33. <a href="sql.html">GRASS SQL interface</a>
  34. </em>
  35. <h2>AUTHOR</h2>
  36. Moritz Lennert (mlennert@club.worldonline.be)
  37. <p><i>Last changed: $Date$</i>