Show all columns for a specified table (Postgres)

SELECT * FROM information_schema.columns WHERE table_schema = 'your_schema' AND table_name = 'your_table'
Source: http://dba.stackexchange.com/questions/22362/how-do-i-list-all-columns-for-a-specified-table

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.