Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgres describe query

select column_name, data_type, character_maximum_length, column_default, is_nullable
from INFORMATION_SCHEMA.COLUMNS where table_name = '<name of table>';
Comment
PREVIOUS NEXT
Code Example
Sql :: how to update column name in psql 
Sql :: host is not allowed to connect to this mysql server 
Sql :: backup mysql data only 
Sql :: how to check current user in mysql 
Sql :: postgresql fill fake data 
Sql :: hour and minute between two datatime sql 
Sql :: add user mysql wordpress 
Sql :: how to know password of mysql root in linux terminal 
Sql :: grant mysql 
Sql :: update query formula in excel 
Sql :: wsl install mysql 
Sql :: combine two columns using sql query 
Sql :: retrieve meaning 
Sql :: hangfire clear all jobs 
Sql :: sql server: select column values as comma separated string 
Sql :: mysql reset root password 
Sql :: check postgresql port windows 
Sql :: mysql check auto increment value 
Sql :: alter database name script 
Sql :: How to convert Varchar to Double in sql? 
Sql :: postgres autoincrement primary key 
Sql :: sql where keyword contains 
Sql :: mysql current date 
Sql :: concate update mysq 
Sql :: how to create enum in postgresql 
Sql :: sql server query all database objects 
Sql :: install mysql workbench ubuntu 20.04 
Sql :: how to get nears location in mysql with latitude and longitude 
Sql :: postgres statistics 
Sql :: sql select second max 
ADD CONTENT
Topic
Content
Source link
Name
6+6 =