Edit postgresql field

[Maurizio1230]

Hi all,

Do you know how to edit a field in POSTGRESQL DATABASE?

Thank you very much

 

[user-7256]

PostgreSQL, Google, and dozens of other sites have nearly unlimited resources for basic documentation questions like this. Try giving it a whirl yourself sometime.

http://www.postgresql.org/docs/8.1/static/ddl-alter.html

 

[Maurizio1230]

Thanks but how can I change Data in a table?
I don't understand from postgresql docs.

 

[Peter]

the link previously posted is for altering the structure of a table not modifying data.

The correct URL is http://www.postgresql.org/docs/current/static/sql-update.html

An example query is:-

UPDATE table_name SET field_name = data;

Thie syntax is exactly the same as MySQL

 

[Maurizio1230]

thank you very much

 

[user-7256]

The link I provided answered his question:

Do you know how to edit a field in POSTGRESQL DATABASE?

A field is part of the table's structure, not data. A contains the basic units of data, the cells.