Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgres convert exisiting column to text

# POSTGRESQL - Convert an existing column to text
ALTER TABLE your_table
ALTER COLUMN your_column TYPE text
Comment

PREVIOUS NEXT
Code Example
Sql :: postgres killing connections on db 
Sql :: restart identity cascade 
Sql :: sql find column name like 
Sql :: mysql add column default value 
Sql :: get all records who register today in mysql 
Sql :: psql autocomplete for mac brew install 
Sql :: oracle current timestamp 
Sql :: sql where last 12 months 
Sql :: vagrant mysql downgrade version 
Sql :: sql server utc to local 
Sql :: for loop postgresql 
Sql :: copy sql table to another table 
Sql :: mysql find foreign key references 
Sql :: oracle activate job 
Sql :: day of week postgresql 
Sql :: sql server list user permissions 
Sql :: how to delete duplicate rows in oracle 
Sql :: drop table if exists oracle 
Sql :: insert random numbers in columns postgress 
Sql :: postgresql if null then 0 
Sql :: mysql get age from date 
Sql :: oracle current sequence value 
Sql :: mysql update inner 
Sql :: select tables with name like mysql 
Sql :: mysql set primary key 
Sql :: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
Sql :: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed 
Sql :: postgres list all roles 
Sql :: can you use a where clause for a child query 
Sql :: oracle last day of month 
ADD CONTENT
Topic
Content
Source link
Name
1+9 =