/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 vote218 views3 answers
Mysql CAST(amount as float)
SQL
2 votes227 views1 answer
Postgresql transaction
SQL
1 vote192 views1 answer
Sql exclude duplicates and find even id
SQL
6 votes281 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
3 votes197 views1 answer
Oracle limit user tablespace
SQL
0 vote177 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote188 views1 answer
Call object contructor and call methods of object
SQL
2 votes273 views2 answers
Set value to null sql
SQL
0 vote240 views1 answer
Postgresql conectar
SQL
5 votes186 views2 answers
Update all rows mysql
SQL

Share