Recent questions tagged PostgreSQL

0 votes

1.9k views

1 answer

postgresql - Heroku "psql: FATAL: remaining connection slots are reserved for non-replication superuser connections"

I'm developing an app on Heroku with a Postgresql backend. Periodically, I get this error message when trying to ... me in the right direction? See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - How to make a select with array contains value clause in psql

I have column arr which is of type array. I need to get rows, where arr column contains value s This query: SELECT ... but why doesn't @> work? See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

postgresql - Postgres: check if array field contains value?

I'm sure this is a duplicate question in the sense that the answer is out there somewhere, but I ... based around more complicated examples. See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

postgresql - docker postgres pgadmin local connection

I have created an ubuntu image with nginx, php and postgres. I want to connect the postgres database in my ... local to make connection work. See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - How do you change the character encoding of a postgres database?

I have a database that was set up with the default character set SQL_ASCII. I want to switch it to UNICODE. Is there an easy way to do that? See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

postgresql - ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user

GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly; The readonly user can connect, see the tables but when it ... 9.1 What I did wrong? See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

postgresql - Psql could not connect to server: No such file or directory, 5432 error?

I'm trying to run psql on my Vagrant machine, but I get this error: psql: could not connect to server: ... postgres psql -d postgres -U postgres See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - Is it possible to have autoincrement number without it being an ID?

I keep googling and find that the only way is to use @Id @GeneratedValue(strategy = GenerationType.Identity) But ... it by manual calculation. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - Returning from a function with OUT parameter

I have an error, but I don't know what the problem is. I want execute a function and return a value ... query has no destination for result data See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - Does a Postgres UNIQUE constraint imply an index?

When adding a unique constraint to a Postgres table does that imply that an index has also been added to that ... have to be added separately? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - Dynamic SQL (EXECUTE) as condition for IF statement

I want to execute a dynamic SQL statement, with its returned value being the conditional for an IF statement: ... variable as the conditional? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - How to convert a postgres database to sqlite

We're working on a website, and when we develop locally (one of us from Windows), we use sqlite3, but ... install postgres on windows? Thanks. See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - How to get function parameter lists (so I can drop a function)

I want to get the SQL to drop a function in PostgreSQL. I write DROP FUNCTION and a get function name from ... the SQL to drop the function? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - Postgres password authentication fails

I tried to login with the postgres user from my windows machine to my server with Pgadmin. But it keeps giving me ... 00:00:00+01 useconfig | See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - python pip install psycopg2 install error

I did a simple pip install psycopg2 on mac system. It installed fine, but when I try to use psycopg2 ... reinstalling, same results. Please help See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - Java Enums, JPA and Postgres enums - How do I make them work together?

We have a postgres DB with postgres enums. We are starting to build JPA into our application. We also have Java ... how to do the postgres side. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

postgresql - Refresh a materialized view automatically using a rule or notify

I have a materialized view on a PostgreSQL 9.3 database which seldom changes (about twice a day). But when it ... that runs every minute or so. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - Polymorphism in SQL database tables?

I currently have multiple tables in my database which consist of the same 'basic fields' like: name ... and multiple specialized tables. See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

postgresql - "psql: could not connect to server: Connection refused" Error when connecting to remote database

I am trying to connect to a postgres database installed in a remote server using the following command: psql -h ... . Hope someone can help. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - How to add "on delete cascade" constraints?

In PostgreSQL 8 is it possible to add ON DELETE CASCADES to the both foreign keys in the following table without ... (gid) ON DELETE CASCADE; See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - How to make connection to Postgres via Node.js

I find myself trying to create a postgres database, so I installed postgres and started a server with initdb /usr/ ... find out what it is. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

postgresql - Permission denied for relation

I tried to run simple SQL command: select * from site_adzone; and I got this error ERROR: permission denied for ... any idea what can be wrong? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - Where are my postgres *.conf files?

I have recently reinstalled postgresql 8.3 on my Ubuntu 8.04 after update. Used EnterpriseDB package. I can ... the postgres *.conf files? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - Compute percents from SUM() in the same SELECT sql query

In the table my_obj there are two integer fields: (value_a integer, value_b integer); I try to compute how many time ... 9.1 with Ubuntu 12.04. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - How do I get a column with consecutive, increasing numbers, without having any numbers missing?

Possible Duplicates: How to show row numbers in PostgreSQL query? Resequencing a column with identifier in Postgresql PostgreSQL ... 2, 4, 5? See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

postgresql - Go and IN clause in Postgres

I am trying to execute the following query against the PostgreSQL database in Go using pq driver: SELECT COUNT(id) ... execute this query in Go? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - Joining Results from Two Separate Databases

Is it possible to JOIN rows from two separate postgres databases? I am working with system with couple databases ... need such a feature. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

postgresql - dynamic sql query in postgres

I was attempting to use Dynamic SQL to run some queries in postgres. Example: EXECUTE format('SELECT ... with query result postgresql See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags