/SQL/SQL column name Postgre

SQL column name Postgre

SQL column name Postgre

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

2

Source: dba.stackexchange.com

Similar codes

0 vote267 views1 answer
Find invalid datetime field
SQL
0 vote267 views1 answer
Get only structure database mysql
SQL
0 vote270 views1 answer
How to find sql server name
SQL
0 vote263 views1 answer
Sql auto_increment syntax
SQL
0 vote254 views1 answer
Sqldf change user
SQL
1 vote272 views1 answer
How do you use sql in you company
SQL
0 vote269 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote274 views1 answer
Update database collation in postgresql
SQL
0 vote230 views1 answer
Jooq finding lastest value in table
SQL
0 vote288 views2 answers
Greater than sql server
SQL

Share