Project

General

Profile

« Previous | Next » 

Revision 12303

schemas/util.sql: remake_diff_table(): add comment on the diff table showing how to view it in human-readable form. (the table unfortunately cannot be materialized in human-readable form, because this would create column name collisions between the two sides.)

View differences:

util.sql
2170 2170
, $$||quote_nullable($3)||$$::regclass
2171 2171
, NULL::$$||$4||$$)
2172 2172
$$);
2173

  
2174
/* the table unfortunately cannot be *materialized* in human-readable form,
2175
because this would create column name collisions between the two sides */
2176
SELECT util.set_comment($1, '
2177
to view this table in human-readable form (with each side''s tuple column
2178
expanded to its component fields):
2179
SELECT (left_).*, (right_).* FROM '||$1||';
2180
');
2173 2181
$_$;
2174 2182

  
2175 2183

  

Also available in: Unified diff