SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[sql] How to change a PG column to NULLABLE TRUE?

How can I accomplish this using Postgres? I've tried the code below but it doesn't work:

ALTER TABLE mytable ALTER COLUMN mycolumn BIGINT NULL;

This question is related to sql postgresql nullable

The answer is

From the fine manual:

ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;

There's no need to specify the type when you're just changing the nullability.

Source: Stackoverflow.com

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to nullable

• Laravel Migration Change to Make a Column Nullable • How to set null to a GUID property • How to set null value to int in c#? • Can't find @Nullable inside javax.annotation.* • Check if Nullable Guid is empty in c# • How to declare a type as nullable in TypeScript? • Java check if boolean is null • How to use @Nullable and @Nonnull annotations more effectively? • Nullable property to entity field, Entity Framework through Code First • The type 'string' must be a non-nullable type in order to use it as parameter T in the generic type or method 'System.Nullable<T>'