/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 vote146 views1 answer
Get number of tables in database sql
SQL
3 votes147 views3 answers
Postgresql random number
SQL
1 vote157 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
1 vote191 views1 answer
Add time to date sql
SQL
8 votes160 views1 answer
Oracle add datafile to tablespace
SQL
0 vote139 views1 answer
Wp_query raw sql
SQL
2 votes149 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote157 views2 answers
Mysql missin expression near on
SQL
0 vote409 views1 answer
Create pl/sql stored procedure
SQL
0 vote139 views1 answer
Postgres read table structure
SQL

Share