Recent questions tagged postgresql

0 votes

809 views

1 answer

postgresql - postgres db files - which file represents the specific table/index?

when i go into sql-8.2/base/ to check how much space does my table take, there are plenty of files named by a ... sql 1.0G Dec 4 11:16 15426228 See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Millisecond resolution of DateTime in Ruby

I have a string like 2012-01-01T01:02:03.456 that I am storing in a Postgres database TIMESTAMP ... millisecond resolution on timestamp fields? See Question&Answers more detail:os...

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

0 votes

929 views

1 answer

postgresql - GROUP BY in UPDATE FROM clause

I really need do something like that: UPDATE table t1 SET column1=t2.column1 FROM table t2 INNER JOIN table t3 ... a different way to 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 - Rails: delete cascade vs dependent destroy

Assuming I have two tables: users and orders. A user has many orders, so naturally there is a foreign key ... in terms of execution speed? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Use psql's copy for a multi-line query

This is a follow-up question from this answer for "Save PL/pgSQL output from PostgreSQL to a CSV file". I need ... ? I'm using psql on Windows. See Question&Answers more detail:os...

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

0 votes

985 views

1 answer

postgresql - How to convert date time into unix epoch value in Postgres?

How do I convert the following format to UNIX timestamps? A value like: 01-02-2015 10:20 PM should be converted ... but its not working for me. See Question&Answers more detail:os...

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

0 votes

945 views

1 answer

postgresql - Point Heroku application to AWS RDS database

I need to point my Heroku application to my AWS RDS database. My RDS database is up and running and has a ... and point my application to it? See Question&Answers more detail:os...

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

0 votes

812 views

1 answer

postgresql - Retrieving all object privileges for specific role

Is there an easy way to enumerate all objects that a specific role has some access privilege to? I know of the ... I would say. Cheers, Patrick See Question&Answers more detail:os...

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

0 votes

854 views

1 answer

postgresql - Java - date saved as the day before

I'm experiencing a very weird behaviour while saving dates on database. On my (Linux centOS 6.2) server I use ... Date(d1.getTime() + hours12); See Question&Answers more detail:os...

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

0 votes

947 views

1 answer

postgresql - Fire trigger on update of columnA or ColumnB or ColumnC

I have the code to fire a trigger only on an update of a single specific column. The trigger is used to fire a ... nature of the word OR :-( See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Is it possible to turn off quote processing in the Postgres COPY command with CSV format?

I have CSV files, tab-separated, fields not wrapped in quotes, where field data can contain characters like single ... is NOT quoted at all? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - customize pager in psql

When I use psql, the command line tool of PostgreSQL, in interactive mode, it lists data as paginated output. ... din't help. Any suggestions? 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 compare two arrays and pick only the non matching elements In postgres

How can I pick only the non matching elements between two arrays. Example: base_array [12,3,5,7,8] temp_array [ ... should be like [12,5] 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: how do you round a timestamp up or down to the nearest minute?

Is there a postgresql function that will return a timestamp rounded to the nearest minute? The input value is a ... value should be a timestamp. 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 install Postgis to a Keg installation of [email protected] using Homebrew?

I have installed [email protected] and Postgis via Homebrew. However, installing Postgis via Homebrew installs the latest ... a later keg formula See Question&Answers more detail:os...

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

0 votes

3.3k views

1 answer

postgresql - How do I use spring data jpa to query jsonb column?

I'm having a problem getting this native query right against a postgres 9.4 instance. My repository has a method: ... {key,subkey}' = 'value' See Question&Answers more detail:os...

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

0 votes

950 views

1 answer

postgresql - Load Postgres dump after docker-compose up

I have a dump.sql file that I would like to load with docker-compose. docker-compose.yml: services: postgres: ... idea how to do this ? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - How can I create a constraint to check if an email is valid in postgres?

How can I create a constraint to use a regular expression in postgres? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - Postgres SSL SYSCALL error: EOF detected with python and psycopg

Using psycopg2 package with python 2.7 I keep getting the titled error: psycopg2.DatabaseError: SSL SYSCALL error: EOF ... an answer soon ... See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Turn postgres date representation into ISO 8601 string

I'm trying to format a Postgres date representation into a ISO 8601 string. I'm assuming that there is a ... happen? Thanks for your help. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

postgresql - Using regex in WHERE in Postgres

I currently have the the following query: select regexp_matches(name, 'foo') from table; How can I rewrite this ... state: 42804 Character: 29 See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Rails + Postgres fe_sendauth: no password supplied

Hi I'm trying to hook up postgresql to my rails project. I'm learning testing but my tests aren't running because ... can chat if it's easier. See Question&Answers more detail:os...

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

0 votes

2.7k views

1 answer

postgresql - ERROR: permission denied for language c

When creating a function like this with a non-super user I am getting the error below: ERROR: permission denied for ... else I am doing wrong? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

postgresql - Check if sequence exists in Postgres (plpgsql)

I'm trying to test, within a stored procedure, whether a sequence already exists. IF EXISTS SEQUENCE seq_name ... . Any help is appreciated! See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

postgresql - SQL Get all records older than 30 days

Now I've found a lot of similar SO questions including an old one of mine, but what I'm trying to do ... date queries. Any help is appreciate. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - SQLAlchemy declarative: defining triggers and indexes (Postgres 9)

Is there a way in the SQLAlchemy class of a table to define/create triggers and indexes for that table? For ... the apps setup then bonus! See Question&Answers more detail:os...

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

0 votes

884 views

1 answer

postgresql - How to list indexes created for table in postgres

Could you tell me how to check what indexes are created for some table in postgresql ? See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

postgresql - How can I stop a Postgres script when it encounters an error?

Is there a way to specify that when executing a sql script it stops when encountering the first error on ... , regardless of previous errors. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags