Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql select all column names

SELECT column_names
  FROM information_schema.columns
 WHERE table_schema = 'your_schema'
   AND table_name   = 'your_table'
     ;
-- just for column names
Comment

PREVIOUS NEXT
Code Example
Sql :: MySQL - Enabling the Event Scheduler 
Sql :: athena query timestamp greater than 
Sql :: oracle create schema 
Sql :: Create a keyspace cassandra 
Sql :: psql list rules 
Sql :: oracle sleep 
Sql :: import dump mysql 
Sql :: mysql count grouped rows 
Sql :: mysql count newlines in field 
Sql :: show user mysql 
Sql :: mysql remove ubuntu 
Sql :: mysql password error create datbase 
Sql :: ms sql how to see active job current run time 
Sql :: show table status command in mysql 
Sql :: jooq convert using gbk 
Sql :: STOP message of how many rows affected sql 
Sql :: zerar auto increment mysql 
Sql :: pl sql dynamic sql drop doesnt work 
Sql :: copy all values of a column to another column in sql in same table 
Sql :: mysql events not work 
Sql :: apex select list ORA-20999 
Sql :: check mysql version phpmyadmin 
Sql :: remove password from root mysql 
Sql :: mysql get character set 
Sql :: mysql mediumint max value 
Sql :: ssh mysql port forwarding 
Sql :: nvl2 syntax 
Sql :: oracle character set 
Sql :: having vs where 
Sql :: import file mysql terminal 
ADD CONTENT
Topic
Content
Source link
Name
6+3 =