deeejay

psql - Prepend table name to column name in a view

Jul 17th, 2015
496
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --1. Using psql, paste query
  2. --2. Copy SQL result
  3. --3. Paste new SQL, execute to create view
  4.  
  5. SELECT 'CREATE OR REPLACE VIEW some_schema.some_view AS SELECT ' ||
  6. (SELECT STRING_AGG(column_name || ' AS some_table_' || column_name, ', ')
  7. FROM information_schema.columns
  8. WHERE table_name = 'some_table'
  9. GROUP BY table_name) ||
  10. ' FROM some_schema.some_table;';
Advertisement
Add Comment
Please, Sign In to add comment