06-03-2013
AFAIK there is no such option in export or import utilities that supports modifying column values.
These utilities are used if your data objects reside on platforms with different hardware and software configurations.
If that is not the case you can use COPY command in which you can specify modified value in SELECT statement.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi folks,
Happy new year.
I have a file 'filename' that i wd like to split basing on the contents in the last column.
The 'filename' content looks like
256772744788,9,11
256772744805,9,11
256772744792,9,11
256775543055,10,12
256782625357,9,12
256772368953,10,13
256772627735,10,13... (3 Replies)
Discussion started by: jerkesler
3 Replies
2. UNIX for Advanced & Expert Users
hi 2 all
i need to get single column from one csv file
anyone help me !
>cat file.csv
name,age
x,1
y,2
z,3
Use code tags please, ty.
in this "file.csv" file i need only name column
can u help me !:b::b: (7 Replies)
Discussion started by: ponmuthu
7 Replies
3. UNIX for Dummies Questions & Answers
Hi...
I have dump in unix machine...How can I this import dump to Oracle database?
Many thanks in advance. (2 Replies)
Discussion started by: agarwal
2 Replies
4. Shell Programming and Scripting
Hi,
I am trying to get the file in particular pattern using shell script. I have to add one column to some other file.
For example consider two file as below.
File1:
name1
name2
name3
File2:
Add1 age1
Add2 age2
Add3 age3
I want this two file in a single file format something like... (3 Replies)
Discussion started by: diehard
3 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump.
Is that possible in oracle. What will be the command for that? (6 Replies)
Discussion started by: Palak Sharma
6 Replies
6. UNIX and Linux Applications
Hi All,
I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server.
Now how to import the dump to the... (3 Replies)
Discussion started by: Palak Sharma
3 Replies
7. UNIX and Linux Applications
Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.
# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y
Export: Release 11.2.0.1.0 -... (2 Replies)
Discussion started by: clerck
2 Replies
8. Shell Programming and Scripting
Hi,
I have 2 csv/txt files with single columns. I am trying to merge them using paste, but its not working..
output3.csv:
flowerbomb
everlon-jewelry
sofft
steve-madden
dolce-gabbana-watchoutput2.csv:
http://www1.abc.com/cms/slp/2/Flowerbomb
http://www1.abc.com/cms/slp/2/Everlon-Jewelry... (5 Replies)
Discussion started by: ajayakunuri
5 Replies
9. Homework & Coursework Questions
1. The problem statement, all variables and given/known data:
are the oracle dump files compatible to direct import into db2?
I already tried many times but it always truncated results.
anyone can help/ advice or suggest?
2. Relevant commands, code, scripts, algorithms:
exp... (3 Replies)
Discussion started by: Sonny_103024
3 Replies
10. Solaris
On an OmniOS server, I removed a single-disk pool I was using for testing.
Now, when I run zpool import it will show it as FAULTED, since that single disk not available anymore.
# zpool import
pool: fido
id: 7452075738474086658
state: FAULTED
status: The pool was last... (11 Replies)
Discussion started by: priyadarshan
11 Replies
LEARN ABOUT DEBIAN
grass-pg
grass-pg(1grass) Grass User's Manual grass-pg(1grass)
NAME
grass-pg - PostgreSQL driver
PostgreSQL driver PostgreSQL driver in GRASS The driver name is 'pg'.
Creating a PostgreSQL database
A new database is created with 'createdb', see the PostgreSQL manual for details.
Connecting GRASS to PostgreSQL
# example for connecting to a PostgreSQL server:
db.connect driver=pg database="host=myserver.osgeo.org,dbname=mydb"
# password is asked interactively if not specified:
db.login user=myname [pass=secret]
db.connect -p
db.tables -p
Supported SQL commands
All SQL commands supported by PostgreSQL. It's not possible to use C-like escapes (with backslash like
etc) within SQL syntax.
Operators available in conditions
All SQL operators supported by PostgreSQL.
Adding an unique ID column
Import vector module require an unique ID column which can be generated as follows in a PostgreSQL table:
echo "
ALTER TABLE mytable ADD ID integer;
CREATE SEQUENCE mytable_seq;
UPDATE mytabe SET ID = nextval('mytable_seq');
DROP SEQUENCE mytable_seq;
" | db.execute
Attribute Converters
CSV import into PostgreSQL:
h copy
COPY t1 FROM 'filename' USING DELIMITERS ',';
pg2xbase: DBF to PostgreSQL converter.
Geometry import from PostgreSQL table
v.in.db creates a new vector (points) map from a database table containing coordinates. See here for examples.
PostGIS: PostgreSQL with vector geometry
PostGIS: adds geographic object support to PostgreSQL.
Example: Import from PostGIS
In an existing PostGIS database, create the following table:
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);
GRASS can import this PostGIS polygon map as follows:
v.in.ogr dsn="PG:host=localhost dbname=postgis user=neteler" layer=test
output=test type=boundary,centroid
v.db.select test
v.info -t test
Geometry Converters
PostGIS with shp2pgsql:
shp2pgsql -D lakespy2 lakespy2 test > lakespy2.sql
e00pg: E00 to PostGIS filter, see also v.in.e00.
GDAL/OGR ogrinfo and ogr2ogr: GIS vector format converter and library, e.g. ArcInfo or SHAPE to PostGIS.
ogr2ogr -f "PostgreSQL" shapefile ??
SEE ALSO
db.connect, db.execute,
Database management in GRASS GIS,
Help pages for database modules,
SQL support in GRASS GIS
PostgreSQL web site,
pgAdmin graphical user interface
Book: PostgreSQL: Introduction and Concepts by Bruce Momjian
PostgreSQL Documentation
PostgreSQL Technical Documentation
GDAL/OGR PostgreSQL driver documentation
MapServer Wiki
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-pg(1grass)