list columns in table postgres

slohobo answered on June 17, 2020 Popularity 9/10 Helpfulness 6/10

answer list columns in table postgres

related how to list columns for particular tables in postgresql

list columns in table postgres

Comment

-- Good for quickly reminding you of what columns exist.
SELECT * FROM mytable WHERE 1=0;

Popularity 9/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: list sql

Link to this answer
Share Copy Link

Contributed on Oct 20 2021

slohobo

0 Answers Avg Quality 2/10

Closely Related Answers

how to list columns for particular tables in postgresql

Comment

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

Popularity 10/10 Helpfulness 10/10 Language sql

Source: dba.stackexchange.com

Tags: list

Link to this answer
Share Copy Link

Contributed on Jun 17 2020

Foolish Falcon

0 Answers Avg Quality 2/10

postgresql list columns

Comment

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

Popularity 9/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: list

Link to this answer
Share Copy Link

Contributed on Apr 30 2021

VasteMonde

0 Answers Avg Quality 2/10

list all tables and columns in postgresql

Comment

CREATE VIEW table_column_info AS

SELECT table_name, STRING_AGG(column_name, ', ') AS columns
FROM information_schema.columns
WHERE table_schema = 'public'
GROUP BY table_name;

SELECT * FROM table_column_info;

Popularity 9/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: list

Link to this answer
Share Copy Link

Contributed on Nov 16 2022

Innocent Iguana

0 Answers Avg Quality 2/10

list columns in table postgres

Contents

More Related Answers