SQL rename columns - Revision history

⚠️MilenaN: Reverted edits by Reverse22 (talk) to last revision by Neteler

2011-12-30T21:35:12Z

Reverted edits by Reverse22 (talk) to last revision by Neteler

← Older revision		Revision as of 21:35, 30 December 2011
Line 16:		Line 16:

	[[Category:FAQ]]		[[Category:FAQ]]

	~~==Other==~~
	~~[http://thetvtopc.com/Reverse_Cell_Phone_Lookup_Number reverse phone lookup]~~

	~~[http://www.prlog.org/11289974-phone-number-lookup-verizon-phone-number-reverse-lookup-to-get-information-you-need-quickly.html phone number lookup]~~

⚠️Reverse22 at 20:57, 30 December 2011

2011-12-30T20:57:25Z

← Older revision		Revision as of 20:57, 30 December 2011
Line 16:		Line 16:

	[[Category:FAQ]]		[[Category:FAQ]]

			==Other==
			[http://thetvtopc.com/Reverse_Cell_Phone_Lookup_Number reverse phone lookup]

			[http://www.prlog.org/11289974-phone-number-lookup-verizon-phone-number-reverse-lookup-to-get-information-you-need-quickly.html phone number lookup]

Neteler: use cmd template

2008-11-11T16:49:21Z

use cmd template

← Older revision		Revision as of 16:49, 11 November 2008
Line 1:		Line 1:
	Q: I have imported successfully a large dataset to GRASS. After the import, the attribute columns are named like this: dbl_1 dbl_2...... I would like to change these names to something more friendly. I've tried some dbf editors but they allow only to change values but not the database structure.		''Q: I have imported successfully a large dataset to GRASS. After the import, the attribute columns are named like this: dbl_1 dbl_2...... I would like to change these names to something more friendly. I've tried some dbf editors but they allow only to change values but not the database structure.''

	A: You can change column names with [http://openoffice.org Openoffice.org] (Version 2). But take care to use 'oobase' (or: File -> New -> Database) to avoid problems with the number of rows. So, use 'oobase' to connect to your dbf file using the dbase driver (in the launch dialog chose "connect to existing database"). Then you don't have any problems with row number limits.		'''A:''' You can change column names with [http://openoffice.org Openoffice.org] (Version 2). But take care to use 'oobase' (or: File -> New -> Database) to avoid problems with the number of rows. So, use 'oobase' to connect to your dbf file using the dbase driver (in the launch dialog chose "connect to existing database"). Then you don't have any problems with row number limits.

	Notes:		Notes:
Line 7:		Line 7:
	* For SQLite, use the [http://sqlitebrowser.sourceforge.net/ SQLiteBrowser] program or the [https://addons.mozilla.org/en-US/firefox/addon/5817 Firefox SQLite Manager plugin].		* For SQLite, use the [http://sqlitebrowser.sourceforge.net/ SQLiteBrowser] program or the [https://addons.mozilla.org/en-US/firefox/addon/5817 Firefox SQLite Manager plugin].

	Alternative: in GRASS 6.3 there is drop column support: so you can add a new column, update it to the one to be renamed, drop the old column.		Alternative: in GRASS >=6.3 there is drop column support: so you can add a new column, update it to the one to be renamed, drop the old column.
	* v.db.renamecol		* {{cmd\|v.db.renamecol}}
	* v.db.dropcol		* {{cmd\|v.db.dropcol}}
	* v.db.addcol		* {{cmd\|v.db.addcol}}

	=== See also ===		=== See also ===

⚠️HamishBowman: v.db.renamecol

2008-05-25T13:32:24Z

v.db.renamecol

← Older revision		Revision as of 13:32, 25 May 2008
Line 8:		Line 8:

	Alternative: in GRASS 6.3 there is drop column support: so you can add a new column, update it to the one to be renamed, drop the old column.		Alternative: in GRASS 6.3 there is drop column support: so you can add a new column, update it to the one to be renamed, drop the old column.
			* v.db.renamecol
			* v.db.dropcol
			* v.db.addcol

	=== See also ===		=== See also ===

⚠️HamishBowman: Firefox SQLite Manager plugin

2008-05-25T13:30:25Z

Firefox SQLite Manager plugin

← Older revision		Revision as of 13:30, 25 May 2008
Line 5:		Line 5:
	Notes:		Notes:
	* In PostgreSQL there is an ALTER TABLE/RENAME COLUMN command.		* In PostgreSQL there is an ALTER TABLE/RENAME COLUMN command.
	* For SQLite, use the [http://sqlitebrowser.sourceforge.net/ ~~sqlitebrowser~~] ~~browser~~.		* For SQLite, use the [http://sqlitebrowser.sourceforge.net/ SQLiteBrowser] program or the [https://addons.mozilla.org/en-US/firefox/addon/5817 Firefox SQLite Manager plugin].

	Alternative: in GRASS 6.3 there is drop column support: so you can add a new column, update it to the one to be renamed, drop the old column.		Alternative: in GRASS 6.3 there is drop column support: so you can add a new column, update it to the one to be renamed, drop the old column.

Neteler: new trick

2007-02-06T13:17:50Z

new trick

← Older revision		Revision as of 13:17, 6 February 2007
Line 6:		Line 6:
	* In PostgreSQL there is an ALTER TABLE/RENAME COLUMN command.		* In PostgreSQL there is an ALTER TABLE/RENAME COLUMN command.
	* For SQLite, use the [http://sqlitebrowser.sourceforge.net/ sqlitebrowser] browser.		* For SQLite, use the [http://sqlitebrowser.sourceforge.net/ sqlitebrowser] browser.

			Alternative: in GRASS 6.3 there is drop column support: so you can add a new column, update it to the one to be renamed, drop the old column.

	=== See also ===		=== See also ===

Neteler: new article

2006-10-03T12:57:39Z

new article

New page

Q: I have imported successfully a large dataset to GRASS. After the import, the attribute columns are named like this: dbl_1 dbl_2...... I would like to change these names to something more friendly. I've tried some dbf editors but they allow only to change values but not the database structure.

A: You can change column names with [http://openoffice.org Openoffice.org] (Version 2). But take care to use 'oobase' (or: File -> New -> Database) to avoid problems with the number of rows. So, use 'oobase' to connect to your dbf file using the dbase driver (in the launch dialog chose "connect to existing database"). Then you don't have any problems with row number limits.

Notes:
* In PostgreSQL there is an ALTER TABLE/RENAME COLUMN command.
* For SQLite, use the [http://sqlitebrowser.sourceforge.net/ sqlitebrowser] browser.

=== See also ===
* [[Openoffice.org with SQL Databases]]

[[Category:FAQ]]