Run the following command: alter table TABLE_NAME alter column COLUMN_NAME type character varying(120); This will extend the character varying column field size to 120. Remember to change TABLE_NAME to the relevant table...
How to copy a columns data from one table into a column in another table using PostgreSQL? Eg. name columns data from the users table into namecolumn in the new_users table. Execute the query below with different column names and table names and all the data for a specific column will be...
Run the following query: SELECT version(); The result will look as below: version ————————————————————————————————— PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.3-5ubuntu4)...
How to create a backup of a PostgreSQL database to a sql file? This sql file then can be used to restore the database on a later stage. Follow the steps below in order to create a...
Use the DISTINCT ON keyword in your query To do a case-insensitive search do the following query SELECT DISTINCT ON(upper(surname)) surname FROM employees ORDER BY upper(surname) This will return non-duplicate surnames.
Type in the following command in postgres using the command line: copy products from ‘/home/user/products.csv’ using delimiters ‘,’ products = (Database Table) ‘/home/user/products.csv‘ = (Location of the csv file) You need...
Type in the following command in postgres using the command line: copy products to ‘/home/user/products.csv’ delimiters ‘,’ CSV HEADER products = (Database Table) ‘/home/user/products.csv‘ = (Location where to save the csv...
Type in the following command in postgres using the command line: copy products to ‘/home/user/products.csv’ delimiters ‘,’ products = (Database Table) ‘/home/user/products.csv‘ = (Location where to save the csv file) You...
