-1
I need to learn how to update my chart. I have the "Person" table, this one has the "Description" column. At the time it was created a maxlenght of 100 characters was added, I need to change this so that 1000 characters can be added.
The detail is that I already have 25 clients, IE, were made 25 database, each one has Person>Description. Is there any way I can update all databases by SQL or only once? If yes, how can I do this?
Detail: I’m using the Postgresql
You need the SQL command to change the column in the table or you want a script to run the command on all 25 database at once?
– Camilo Santos
I want to know how to run SQL all at once...
– Eluander J. F. Lopes
From what I understand you want a script to run in 25 instances of "equal" database. You can create a precedent and make a loop to go through all its instances and run the alter table for each one. An SQL that runs in 2 or more instances is not possible.
– Rafael Christófano
Got it, never used scripts, you could give me an example of how I can do this?
– Eluander J. F. Lopes