/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 vote386 views1 answer
Reindex mssql table
SQL
2 votes371 views2 answers
Convert_tz mysql
SQL
1 vote336 views1 answer
How to give access to database in postgresql server to another user
SQL
1 vote363 views1 answer
Find a column in all tables postgres
SQL
0 vote361 views1 answer
Java mysql swing example
SQL
0 vote326 views1 answer
How to get n result in sql
SQL
0 vote357 views2 answers
Postgresql variable in query
SQL
3 votes337 views2 answers
How to View column names of a table in SQL
SQL
0 vote379 views1 answer
Sql: extract day text from datetime value
SQL
0 vote331 views2 answers
Update all linkedserver tables with openquery on db
SQL

Share