Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 27th, 2012  |  syntax: None  |  size: 1.71 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. select
  2. 'INSERT INTO "object"(
  3.             id, parent, active, created, changed, "owner", groupo, revised_by,
  4.             recommended, sort, "mode", refs_to_us, "template", "type", meta_type,
  5.             "name", description, keywords, data, detach, hidden, int0, int1,
  6.             int2, int3, int4, str0, str1, str2, str3, str4, displaypri, urlname,
  7.             orig)
  8.     VALUES ('''||COALESCE(id::varchar, '')||''', '''||COALESCE(parent::varchar, '')||''','''||COALESCE(active::varchar,'')||''',
  9.             '''||COALESCE(created::varchar, '')||''','''||COALESCE(changed::varchar, '')||''', '''||COALESCE(owner::varchar, '')||''',
  10.             '''||COALESCE(groupo::varchar, '')||''','''||COALESCE(revised_by::varchar, '')||''','''||COALESCE(recommended::varchar, '')||''',
  11.             '''||COALESCE(sort::varchar, '')||''','''||COALESCE(mode, '')||''','''||refs_to_us||''',
  12.             '''||COALESCE(template, '')||''','''||COALESCE(type, '')||''','''||COALESCE(meta_type, '')||''',
  13.             '''||COALESCE(name, '')||''','''||COALESCE(description, '')||''','''||COALESCE(keywords, '')||''',
  14.             '''||COALESCE(data, '')||''','''||COALESCE(detach::varchar, '')||''','''||COALESCE(hidden::varchar, '')||''',
  15.             '''||COALESCE(int0::varchar, '')||''','''||COALESCE(int1::varchar, '')||''','''||COALESCE(int2::varchar, '')||''',
  16.             '''||COALESCE(int3::varchar, '')||''','''||COALESCE(int4::varchar, '')||''','''||COALESCE(str0, '')||''',
  17.             '''||COALESCE(str1, '')||''','''||COALESCE(str2, '')||''','''||COALESCE(str3, '')||''',
  18.             '''||COALESCE(str4, '')||''','''||COALESCE(displaypri::varchar, '')||''','''||COALESCE(urlname, '')||''',
  19.             '''||COALESCE(orig::varchar, '')||''');'
  20. from object where parent = 1289
create a new version of this paste RAW Paste Data