-
How to Import CSV File Data Into a PostgreSQL Table
We have different data sources for databases, especially during test case design, CSV files adds more compatibility and flexibility. TL;DR: COPY tablename FROM ‘/path/to/file.csv’ WITH (FORMAT csv); CSV Format CSV stands for comma separated value. It’s a portable data format, stores data in a text format separated with commas. Impoting CSV Into a PostgreSQL Table…
-
How to Change a PostgreSQL User Password
That command is one of the simplest and most common one around different database engines. (Excluding Db2-like Db engines, because it uses OS to validate passwords) Alter is the command we use to change / update an attribute or object in database engines. So simply, change user’s password in PostgreSQL as: Of course, you need…