Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get information about data types in postgreSQL

-- Getting information about user-defined data types
SELECT typename, typecategory
FROM pg_type
WHERE typename = '____';

SELECT column_name, data_type, udt_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = '______';
Comment

PREVIOUS NEXT
Code Example
Sql :: install mysql 
Sql :: changing name of column and datatype in sql 
Sql :: sql rownum 
Sql :: operator in sql 
Sql :: frename oracle 
Sql :: change sql global mode 
Sql :: sql select like 
Sql :: azure check access to sql database 
Sql :: mysql workbench download 
Sql :: ALTER TABLE CHANGE TABE SPACE ORACLE 
Sql :: how to check common records in 2 table 
Sql :: calculer pourcentage mysql 
Sql :: top frequency in sql server 
Sql :: sql order of execution 
Sql :: insufficient privileges while creating view in sql oracle 
Sql :: mysql update multiple columns 
Sql :: sql with as 
Sql :: sql check constraint 
Sql :: SQL/delete 
Sql :: psql store procedure-return multiple table values 
Sql :: cast as decimal postgresql 
Sql :: find current server name for SSMS 
Sql :: postgres create trigger if not exists 
Sql :: convert minutes to hours in sql 
Sql :: reset postgresql password windows 
Sql :: mysql begin statement 
Sql :: mysql shell set time_zone 
Sql :: postgres drop type 
Sql :: character count sql 
Sql :: mysql insert into multiple tables 
ADD CONTENT
Topic
Content
Source link
Name
9+9 =