Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql alter column data type from integer to integer array

ALTER TABLE test.test_id
    ALTER COLUMN test_id TYPE INTEGER[]
    USING array[test_id]::INTEGER[];
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle sql trigger select into 
Sql :: local sql server 
Sql :: get month from date sql server 
Sql :: db count rows 
Sql :: mysql max connections exceeded max_connections_per_hour 
Sql :: postgres trim string 
Sql :: mysql stored procedure insert if not exists 
Sql :: mysql loop through databases and execute query 
Sql :: psql: error: FATAL: database "odoo" does not exist 
Sql :: convert .mdf to .bak 
Sql :: mysql multiple left joins on same table 
Sql :: postgresql sum 
Sql :: mysql regex select 
Sql :: mamp mysql password 
Sql :: replace function in sql 
Sql :: how use trigger in sql 
Sql :: oracle kill sessions script 
Sql :: sql date before 
Sql :: connect laravel to mysql on mac 
Sql :: sql update subtract value 
Sql :: insert set mysql 
Sql :: store date time in mysql 
Sql :: inner join vs outer join 
Sql :: sqlite output query to csv 
Sql :: sql server in python 
Sql :: in sqlalchemy 
Sql :: SQL Server dynamic pivot unknown number of columns 
Sql :: SQL Modulo (Remainder) Operator 
Sql :: SQL Query Records Using Dates 
Sql :: Oracle Function execution 
ADD CONTENT
Topic
Content
Source link
Name
2+1 =