gtallen1187/find_table_columns.sql

Created November 14, 2018 23:48

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/gtallen1187/d5a820f1243641562fea19348b273f82.js"></script>
Save gtallen1187/d5a820f1243641562fea19348b273f82 to your computer and use it in GitHub Desktop.

Download ZIP

List all column names for a given table (psql)

Raw

find_table_columns.sql

	SELECT *
	FROM information_schema.columns
	WHERE table_schema = 'your_schema'
	AND table_name = 'your_table'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment