By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,638 Members | 2,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,638 IT Pros & Developers. It's quick & easy.

Is it possible to search and replace in database?

P: 2
Hi,

Is it possible to search some word and replace with another word in Postgres.
For instance i have a some 3000 description in database like
Ca. 45m, north district of Columbia.

i want to search for word 'Ca.' and replace it with 'Circa'.
is it possible to do that by query.

Thanks
G
Mar 15 '11 #1
Share this Question
Share on Google+
4 Replies


Expert 100+
P: 700
What is a 'description'? Column in a table? Columns in a tables?
Mar 15 '11 #2

P: 2
The 'description' is a column name that contain some text like "Ca. 45m, north district of Columbia." or may be longer than this. All i want to do is to find from the description column the rows that contain text having "Ca." anywhere in that text and replace it with "Circa".
I hope i am clear this time.

Thanks
G
Mar 16 '11 #3

Rabbit
Expert Mod 10K+
P: 12,366
Doesn't PostgreSQL have a Replace function?
Mar 16 '11 #4

Expert 100+
P: 700

Post your reply

Sign in to post your reply or Sign up for a free account.