Recent questions tagged PostgreSQL

0 votes

979 views

1 answer

postgresql - How to get min/max of two integers in Postgres/SQL?

How do I find the maximum (or minimum) of two integers in Postgres/SQL? One of the integers is not a column ... = MAXIMUM(my_column - 10, 0); See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - python postgres can I fetchall() 1 million rows?

I am using psycopg2 module in python to read from postgres database, I need to some operation on all rows in a ... the smarter way to do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

932 views

1 answer

postgresql - Unique model field in Django and case sensitivity (postgres)

Consider the following situation: - Suppose my app allows users to create the states / provinces in their ... some other solution exists? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - get last three month records from table

How to get last 3 months records from the table. SELECT * from table where month > CURRENT_DATE-120 and month ... month record from the table. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

861 views

1 answer

postgresql - sql query that groups different items into buckets

I am trying to write a query that returns the count of items whose price falls into certrain buckets: For example ... do this in an sql query? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

952 views

1 answer

postgresql - How to change the template database collection coding

I want build new postgreSQL database by: CREATE DATABASE newdb WITH OWNER = postgres ENCODING = 'UTF8' ... the template database collection? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - Changing a postgres containers server port in Docker Compose

I am trying to deploy a second database container on a remote server using Docker compose. This postgresql server ... container for this job. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

978 views

1 answer

postgresql - OFFSET vs. ROW_NUMBER()

As we know, Postgresql's OFFSET requires that it scan through all the rows up until the point it gets to ... temp tables for large pagination ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - Postgres integer arrays as parameters?

I understand that in Postgres pure, you can pass an integer array into a function but that this isn't ... kinds of parameters into postgres? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

939 views

1 answer

postgresql - Typecast string to integer

I am importing data from a table which has raw feeds in Varchar, I need to import a column in varchar into a ... or null into the new table. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - Getting "[archiver] unsupported version (1.13) in file header" when running pg_restore

I just upgraded to postgres 10.2 on mac os which matches 10.2 on heroku. I'm trying to download a copy ... db:create and db:migrate just fine. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

postgresql - I want to restore the database with a different schema

I have taken a dump of a database named temp1, by using the follwing command $ pg_dump -i -h localhost ... other method also be appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - Display select results vertically in psql, as is done by MySQL's G

In MySQL, you can terminate a select query with G (as opposed to g) to display the results vertically: ... thing for PostgreSQL using psql? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

842 views

1 answer

postgresql - Postgres dump of only parts of tables for a dev snapshot

On production our database is a few hundred gigabytes in size. For development and testing, we need to ... general advice also appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

978 views

1 answer

postgresql port confusion 5433 or 5432?

I have installed postgresql on OSX. When I run psql, I get $ psql psql: could not connect to server: No such ... in the right place by default? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - how to execute a .sql script on heroku?

I have a .sql file with a bunch of insert commands that I want to execute on my postgres database on heroku. ... . Are there any other options? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

991 views

1 answer

postgresql - How do I import modules or install extensions in Postgres 8.4?

I'm trying to import several modules that come bundled with 8.4.1 postgres, and all the commands to do so ( ... cannot be found. Please help me. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

postgresql - Django+Postgres: "current transaction is aborted, commands ignored until end of transaction block"

I've started working on a Django/Postgres site. Sometimes I work in manage.py shell, and accidentally do some DB ... to do from the shell.) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - How connect Postgres to localhost server using pgAdmin on Ubuntu?

I installed Postgres with this command sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev Using ... can I fix it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

977 views

1 answer

postgresql - Find the host name and port using PSQL commands

I have PSQL running, and am trying to get a perl application connecting to the database. Is there a command to ... the database is running on? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

985 views

1 answer

postgresql - Select datatype of the field in postgres

How do I get datatype of specific field from table in postgres ? For example I have the following table, ... . Is there any possibility ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

885 views

1 answer

postgresql - Socket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)

I just upgraded my MacMini Server from Lion Server to Mountain Lion using OS X Server. I am having the ... www.youtube.com/watch?v=y1c7WFMMkZ4 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

980 views

1 answer

postgresql - psql - save results of command to a file

I'm using psql's dt to list all tables in a database and I need to save the results. What is the syntax to ... of a psql command to a file? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

842 views

1 answer

postgresql - Postgres function NULL value for row that references NEW

I have a trigger setup to fire after a row is updated or inserted for table A. There is also a table B ... the boolean value upon an update? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

914 views

1 answer

postgresql - Get default serial value after INSERT inside PL/pgSQL

I have a table. I wrote a function in plpgsql that inserts a row into this table: INSERT INTO simpleTalbe ( ... , is there a better solution? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

postgresql - Error creating a spatial database. ERROR : could not load library "/usr/pgsql-9.1/lib/rtpostgis-2.0.so"

I am running PostgreSQL 9.1 with Postgis 2.0 on Fedora 15. When trying to install the raster support, psql -d ... x86_64 1.7.3-14.fc15 @updates See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

postgresql - postgres rename database not working

bin]# ./createdb cx123 -U postgres [bin]# ./createdb cx111 -U postgres [bin]# ./psql -d cx123 -U postgres ... 222, any idea? Thanks a lot. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.5k views

1 answer

postgresql - PHP pg_prepare() table name as parameter

I'm trying to convert this query from a normal pg_query() to pg_prepare() & pg_execute(). Its a generic ... a better approach to this problem? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags