Answers for "how do i view the contents of a table in postgresql?"

SQL
1

describe table query in postgresql

select column_name, data_type, character_maximum_length, column_default, is_nullable
from INFORMATION_SCHEMA.COLUMNS where table_name = '<name of table>';
Posted by: Guest on June-25-2021
0

show data in table postgres

SELECT * FROM mytablename;
Posted by: Guest on July-09-2021

Code answers related to "how do i view the contents of a table in postgresql?"

Code answers related to "SQL"

Browse Popular Code Answers by Language