/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

3 votes362 views2 answers
Monthname sql
SQL
3 votes387 views1 answer
Only join in sql
SQL
0 vote360 views1 answer
Copy Table from SQL to CSV
SQL
0 vote386 views1 answer
Show all sequences postgres
SQL
1 vote353 views2 answers
Oracle list partitioned tables
SQL
3 votes367 views1 answer
Set default today mysql
SQL
4 votes350 views1 answer
Select nls_date_format
SQL
0 vote389 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
4 votes335 views1 answer
Update table from another table oracle
SQL
5 votes342 views2 answers
Oracle to_timestamp
SQL

Share