Skip to content

Instantly share code, notes, and snippets.

@RhysC

RhysC/generate_select.sql

Created July 6, 2017 08:20
Show Gist options
  • Save RhysC/3497dfe5da1d15a210f24a811e1d2963 to your computer and use it in GitHub Desktop.
Save RhysC/3497dfe5da1d15a210f24a811e1d2963 to your computer and use it in GitHub Desktop.
Download ZIP
Generate Select * (with column names defined ) in postgres
Raw
generate_select.sql
SELECT 'SELECT ' || string_agg(column_name, ', ') || ' FROM ' || table_name
FROM information_schema.columns
WHERE table_schema='my_schema'
GROUP BY table_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment