The PostgreSQL Operator is now available in the https://operatorhub.io and in a good state for you. Note that it was NOT just … More
Tag: postgreSQL
PostgreSQL : How to do research using geolocation in PostgreSQL?
Use PostGIS for do this. You can with PostGIS consult by geographic coordinates using as latitude and longitude, or even … More
PostgreSQL: How to remove a column from a table ?
Use this sintaxe: ALTER TABLE {TABLE_NAME} DROP COLUMN {COLUMN_NAME}; Example: ALTER TABLE material DROP COLUMN classificacao;
PostgreeSQL : How to consult the size of one column ?
SELECT atttypmod -4 FROM pg_attribute WHERE attrelid = ‘Table’::regclass AND attname = ‘column’;
PostgreeSQL : How change the size of one column ?
UPDATE pg_attribute SET atttypmod = (your new size) + 4 WHERE attrelid = ‘(table name)’::regclass AND attname = ‘(column name)’; … More
Hibernate : How to map boolean definitions column for postgreSQL?
@NotNull @Column(name = “column_name”, columnDefinition = “boolean default true”) private boolean columnName ;
PostgreSQL : Useful command line tips
How to access my postgree ? $psql -h server -U userName How to list my existing databases ? $\l How … More