Can postgres column types be updated or do I need to make a new db? | Railway | Page 1

hard harnessBOT Jun 16, 2023, 10:32 AM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

marble plazaBOT Jun 16, 2023, 10:32 AM

#

Project ID: N/A

hollow grail Jun 16, 2023, 10:39 AM

#

ALTER TABLE table_name ALTER COLUMN column_name TYPE column_definition;

#

Literally a Google search

#

In that case i don't know, i don't use the gui

hollow grail Jun 16, 2023, 11:45 AM

#

you should be able to connect to it via psql tho

opal sparrow Jun 16, 2023, 12:38 PM

#

You would need to use a 3rd party client such as DBeaver, Beekeeper, DataGrip, or even PGAdmin, to connect to the database and run your queries. The web based UI is not going to have all the features that you are looking for. It’s more geared as an overview of your database than anything else

#Can postgres column types be updated or do I need to make a new db?