how does one replace a row in Postgresql? (ala MySQL REPLACE)

Поиск
Список
Период
Сортировка
От Terrence Brannon
Тема how does one replace a row in Postgresql? (ala MySQL REPLACE)
Дата
Msg-id B9A8DB2D-EE83-11D5-9845-003065C2A10C@mac.com
обсуждение исходный текст
Ответ на Re: Can anybody help me with SQL?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: how does one replace a row in Postgresql? (ala MySQL REPLACE)  (Philip Hallstrom <philip@adhesivemedia.com>)
Re: how does one replace a row in Postgresql? (ala MySQL REPLACE)  (Bruno Wolff III <bruno@[66.92.219.49]>)
Numbering Rows (SEQUENCE, OID) questions  (Terrence Brannon <metaperl@mac.com>)
Список pgsql-sql
A common task is to check to see if a row with a certain primary 
key exists before inserting it. If the row exists, then you 
simply update/overwrite its contents with the new row data. 
Otherwise you insert it.

MySQL has a REPLACE command which does this.

I didn't see one in the Postgresql manual. How do you do this in 
Postgresql?



В списке pgsql-sql по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Indices
Следующее
От: Philip Hallstrom
Дата:
Сообщение: Re: how does one replace a row in Postgresql? (ala MySQL REPLACE)