Recent questions tagged PostgreSQL

0 votes

1.1k views

1 answer

postgresql - How do I remove all spaces from a field in a Postgres database in an update query?

What would be the proper syntax used to run an update query on a table to remove all spaces from the values ... AdamNoel' I have like 30k rows See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Calculating a date in Postgres by adding months?

I have a postgres table that has the following fields start_date,duration duration contains any number of months, so to ... Hat 4.1.2-48) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - B+ tree or B-tree

I am learning about postgresql internals and I am wondering or postgresql B-tree index is actually classic B-tree ... keys or key-value pairs? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Return dynamic table with unknown columns from PL/pgSQL function

I need to create a function that checks on a given table if the infowindow field exists. If it exists the function ... 't know how to do it. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

postgresql - ERROR: COPY delimiter must be a single one-byte character

I want to load the data from a flat file with delimiter "~,~" into a PostgreSQL table. I have tried it ... must be a single one-byte character See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - Multiple databases in docker and docker-compose

I have a project consisting of two main java apps that use eight postgres databases, so is there a way in docker ... in what database? Tnx, Tom See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Does adding a null column to a postgres table cause a lock?

I think I read somewhere that running an ALTER TABLE foo ADD COLUMN baz text on a postgres database will not cause a ... if this is true or not? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Why can't I see the column names of a table?

So I made some tables programatically and I want to verify it's structure is what I think it is. >Rocko=# c ... "? What's going on here? See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - how to fix "OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly"

Services My service based on flask + postgresql + gunicorn + supervisor + nginx When deploying by docker, after ... True db = SQLAlchemy() See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - Getting date with timezone offset

I am trying to extract the date from a query in postgres. The timestamp is stored as UTC, so if I have 1 ... in this case the pacific timezone. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

postgresql - Rails: No connection pool for ActiveRecord::Base

I'm trying to use rails 4.2.6 to develop an app. I'm trying to use postgres for database. Server starts ... : <<: *default database: myDbName See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Restore dump on the remote machine

I've got my own machine with postgres dmp file, which I want to restore on the remote virtual machine (e ... the virtual machine is 20GB. Thanks 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 do I get "gem install" to work on OS X Lion with Ruby 1.8.7 without seg faulting?

I am novice rails/terminal user and just did a fresh Lion install + Xcode after that. Installed RVM but when I ... must use ruby v1.8.7. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Postgres connection has been closed error in Spring Boot

I am running a Spring Boot application to create REST apis. Often I get an error saying that the database ... DB. Why is this happening? 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 on Heroku and dumping single table to dump file

I am using Postgres on Heroku and am needing to dump one table from my production DB and dump it into my ... to import into my staging db. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Cannot connect to postgres from remote host

I have a database server (192.168.1.50) running postgres. I have created a database named "testdb" and a user ... on port 5432? Any idea ? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Windows PSQL command line: is there a way to allow for passwordless login?

My goal is to be able to fire off a command without having to be prompted for my password. Is there any ... could do this for windows. Thanks! See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql error PANIC: could not locate a valid checkpoint record

When I load up the postgres server (v9.0.1) i get a panic that prevents it from starting: PANIC: could not ... record How can I fix this? See Question&Answers more detail:os...

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

0 votes

3.2k views

1 answer

postgresql - Which data type for latitude and longitude?

I am newbie to PostgreSQL and PostGIS. I want to store latitude and longitude values in PostgreSQL 9.1.1 ... use for latitude and longitude? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - SQL query to get all values a enum can have

Postgresql got enum support some time ago. CREATE TYPE myenum AS ENUM ( 'value1', 'value2', ); How do I get ... in the enum with a query? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Recursive CTE concatenate fields with parents from arbitrary point

How can I concatenate a list of parent items in a RECURSIVE CTE with PostgreSQL (version 10.2)? For example, I ... of the item and parents). 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 id from INSERT or SELECT

I've this function that inserts a row into a city table without duplicates. It returns the id of the inserted row: ... . How can I do this? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - PHP and Postgres: catching errors?

How should I prepare the code if it something fails? With try-catch statement or? function delete_question ( ... ( $question_id ) ); See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - PL/pgSQL anonymous code block

In PostgreSQL 9.0 I have this PLPGSQL anonymous code block: DO $$ DECLARE bigobject integer; BEGIN SELECT lo_creat(- ... t find mistake in code. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - Django + Psycopg2: InterfaceError: only protocol 3 supported

When loading pages in my Django + Postgresql setup I occasionally get this error but not all the time: psycopg2 in ... string for default. } } See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - Postgres UTC date format & epoch cast, sign inversion

Could someone explain me this sign inversion, i'm lost here... SELECT EXTRACT(EPOCH FROM '01-01-1970 00:00:00 UTC+ ... => -3600 Postgres 8.3.14 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 write a function that returns text or integer values?

I'm using PostgreSQL 9.2.4. postgres=# select version(); version ----------------------------- ... purpose. Is there any way to solve this? 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 to tell if record has changed in Postgres

I have a bit of an "upsert" type of question... but, I want to throw it out there because it's a little ... think the best way to solve it is. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags