/SQL/Postgresql list columns

Postgresql list columns

List columns in table postgres

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

1

Postgresql list columns

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

0

Similar codes

0 vote115 views1 answer
Implicit inner join table alias
SQL
0 vote131 views1 answer
Mariadb used space
SQL
0 vote107 views1 answer
Import all databases mysql
SQL
1 vote118 views1 answer
How to select multiple columns from different tables in mysql
SQL
4 votes108 views1 answer
Oracle select first 10 rows
SQL
6 votes103 views1 answer
Oracle trigger after logon on database
SQL
0 vote115 views1 answer
Get server date mysql
SQL
11 votes230 views2 answers
Import mysql dump command line windows
SQL
2 votes102 views2 answers
Postgresql date at timezone
SQL
3 votes121 views2 answers
Oracle apex view logs
SQL

Share