/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 vote116 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote130 views1 answer
Docker open terminal mysql server
SQL
1 vote142 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote125 views3 answers
Duplicate row mysql
SQL
0 vote112 views1 answer
Tsql delete all rows
SQL
0 vote124 views1 answer
Oracle search in date columns
SQL
9 votes112 views4 answers
Add primary key to existing table sql
SQL
13 votes119 views1 answer
Select count of distinct values sql
SQL
0 vote109 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote119 views1 answer
Sql alternative to max statement
SQL

Share