PostgreSQL 8.4.22 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Fast Forward | Next |
dblink_build_sql_delete(text relname, int2vector primary_key_attnums, int2 num_primary_key_atts, text[] tgt_pk_att_vals_array) returns text
dblink_build_sql_delete
can be
useful in doing selective replication of a local table to a
remote database. It builds a SQL DELETE
command that will delete the row with the given primary key
values.
Name of a local relation, for example foo or myschema.mytab. Include double quotes if the name is mixed-case or contains special characters, for example "FooBar"; without quotes, the string will be folded to lower case.
Attribute numbers (1-based) of the primary key fields, for example 1 2.
The number of primary key fields.
Values of the primary key fields to be used in the resulting DELETE command. Each field is represented in text form.