You need to supply a format mask. In PostgreSQL there is no default: select to_char(1234, ‘FM9999′); If you don’t know how many digits there are, just estimate the maximum: select to_char(1234, ‘FM999999999999999999′); If the number has less digits, this won’t have any side effects. If you don’t need any formatting (like decimal point, thousands separator) … Read more
Here is a way to restore from a file located on the host machine: docker exec -i container_name pg_restore -U postgres_user -v -d database_name < /dir_backup_outside_container/file_name.tar
psql’s \copy (note the backslash) lets you copy to/from remote databases and does not require superuser privileges. psql \ -h $hostname -d $dbname -U $username \ -c “\copy mytable (column1, column2) from ‘/path/to/local/file.csv’ with delimiter as ‘,'” https://www.postgresql.org/docs/current/sql-copy.html
Since there hasn’t been a suggested answer I am posting my solution. Short version: decrease the connection pool size in test properties: spring.datasource.hikari.maximum-pool-size=2 Longer version: Spring Boot 2 uses HikariCP by default for connection pooling, which has a default value of 10 for connection pool size (as of Jan 2019). While running a lot of … Read more
You should be able query the pg_class table to see if the relname exists. IF EXISTS (SELECT 0 FROM pg_class where relname=”<my sequence name here>” ) THEN –stuff here END IF;
I used ST_DUMP to convert a table of multipolygon geometries in PostgreSQL to a new table with polygon geometries and other columns of data. CREATE TABLE poly AS –poly will be the new polygon table WITH dump AS ( SELECT id, test, –columns from your multipolygon table (ST_DUMP(geometry)).geom AS geometry FROM multi –the name of … Read more
The psql binary for Postgres.app is inside the application bundle and you’ll have to add the appropriate directory to your PATH. From the fine manual: Configure your $PATH Postgres.app includes many command line tools. If you want to use them, you must configure the $PATH variable. If you are using bash (default shell on OS … Read more
Solved it by setting PGSSLMODE (http://www.postgresql.org/docs/9.0/static/libpq-envars.html) on Heroku. It tells PostgreSQL to default to SSL. $ heroku config:set PGSSLMODE=require
Three possible causes: One or more lines of your file has only 4 or fewer space characters (your delimiter). One or more space characters have been escaped (inadvertently). Maybe with a backslash at the end of an unquoted value. For the (default) text format you are using, the manual explains: Backslash characters (\) can be … Read more