hello,

I have a table with 10 columns. The primary column is oid and account_number.

Now I have to export only one row from this table and need to change the account number with a dummy number.
Then after I have to import this data to my test system.

please advise, how can i do this.

when I do the select col1, col1,col3.....col10 for export and import, should it be in the same order?

Thanks. Valan

if the row is not important : export.. fetch first row only
or if you know the key : export .. where key=x
account_number can be forced in export with literal
you can export in any order .. select col1,col2...
at import the same : insert into ..(col1,col2
see import syntax
IMPORT