how to list the column names in a particular table using postgresql command line

Jeevachaithanyan Sivanandan - Dec 12 '23 - - Dev Community

how to list the column names in a particular table using postgresql command line


SELECT column_name
FROM information_schema.columns
WHERE table_name = 'account_account';
Enter fullscreen mode Exit fullscreen mode
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .