Recent questions tagged PostgreSQL

0 votes

979 views

1 answer

postgresql - Postgres: How to convert a json string to text?

Json value may consist of a string value. eg.: postgres=# SELECT to_json('Some "text"'::TEXT); to_json ------- ... P.S. I'm using PostgreSQL 9.3 See Question&Answers more detail:os...

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

0 votes

652 views

1 answer

postgresql - Can I make a plpgsql function return an integer without using a variable?

Something like this: CREATE OR REPLACE FUNCTION get(param_id integer) RETURNS integer AS $BODY$ BEGIN SELECT col1 ... DECLARE just for this. See Question&Answers more detail:os...

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

0 votes

705 views

1 answer

postgresql - Postgres FOR LOOP

I am trying to get 25 random samples of 15,000 IDs from a table. Instead of manually pressing run every time, ... random() limit 15000 end loop See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

postgresql - How to create index on JSON field in Postgres?

In PostgreSQL 9.3 Beta 2 (?), how do I create an index on a JSON field? I tried it using the -> ... a default operator class for the data type. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

postgresql - Postgres JSON data type Rails query

I am using Postgres' json data type but want to do a query/ordering with data that is nested within the json. I want to ... ", "id"=>"123"} ] } See Question&Answers more detail:os...

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

0 votes

742 views

1 answer

postgresql - replace all instances of a string within text field

In postgresql, how do I replace all instances of a string within a database column? Say I want to replace all ... the best way to do this? See Question&Answers more detail:os...

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

0 votes

900 views

1 answer

postgresql - Buffers (Circle) in PostGIS

I have to extend the normal GeoJSON format to add some unsopported polygon like Circle. { "type": "Circle", ... that solution doesn't works. See Question&Answers more detail:os...

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

0 votes

978 views

1 answer

postgresql - Postgres sql insert query syntax error from phpPgAdmin

Trying to execute a standard insert query, but it doesn't work. INSERT INTO users (vk_id, eu_name, eu_society, ... What is causing this error? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Compare arrays for equality, ignoring order of elements

I have a table with 4 array columns.. the results are like: ids signed_ids new_ids new_ids_signed {1,2,3} ... the order of the elements? See Question&Answers more detail:os...

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

0 votes

687 views

1 answer

postgresql - Optimize Postgres timestamp query range

I have the following table and indices defined: CREATE TABLE ticket ( wid bigint NOT NULL DEFAULT nextval(' ... done to optimize it? See Question&Answers more detail:os...

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

0 votes

786 views

1 answer

postgresql - How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres?

How to add a new column in a table after the 2nd or 3rd column in the table using postgres? My ... ADD COLUMN contract_nr int after owner_id See Question&Answers more detail:os...

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

0 votes

890 views

1 answer

postgresql - Creating temporary tables in SQL

I am trying to create a temporary table that selects only the data for a certain register_type. I wrote this query ... is wrong with the query? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

postgresql - Double colon (::) notation in SQL

Have picked up someone's code and this is a part of a where clause, anyone know what the double colon indicates? b ... INTERVAL '1 DAY 7:20:00' See Question&Answers more detail:os...

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

0 votes

717 views

1 answer

postgresql - uWSGI, Flask, sqlalchemy, and postgres: SSL error: decryption failed or bad record mac

I'm trying to setup an application webserver using uWSGI + Nginx, which runs a Flask application using SQLAlchemy to ... what needs to be done. See Question&Answers more detail:os...

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

0 votes

704 views

1 answer

postgresql - Copy a few of the columns of a csv file into a table

I have a CSV file with 10 columns. After creating a PostgreSQL table with 4 columns, I want to copy some of 10 ... should be like: x2 x5 x7 x10 See Question&Answers more detail:os...

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

0 votes

910 views

1 answer

postgresql - gem install pg --with-pg-config works, bundle fails

WhenI run (as root) gem install pg -v '0.12.0' -- --with-pg-config=/usr/pgsql-9.1/bin/pg_config I ... -devel and ruby-devel. Running CentOS 6. See Question&Answers more detail:os...

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

0 votes

776 views

1 answer

postgresql - Copy a table from one database to another in Postgres

I am trying to copy an entire table from one database to another in Postgres. Any suggestions? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Rails: PG::UndefinedTable: ERROR: relation "..." does not exist

On migration I get the following error message: PG::UndefinedTable: ERROR: relation "actioncodes" does not exist : ... "actioncode_ids" ("id") See Question&Answers more detail:os...

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

0 votes

920 views

1 answer

postgresql - Connect to Postgres via SSL using R

I have the same question that was asked here Connect to Redshift via SSL using R However, the answer given ... in advance for any help! See Question&Answers more detail:os...

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

0 votes

622 views

1 answer

postgresql - Function executes faster without STRICT modifier?

I stumbled upon a slump in performance when a simple SQL function is declared STRICT while answering this question. ... - Total runtime: 60 ms See Question&Answers more detail:os...

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

0 votes

928 views

1 answer

postgresql - pgAdmin III Why query results are shortened?

I've recently installed pgAdmin III 1.18.1 and noticed a strange thing: Long json query results are ... help me disable this shortening? See Question&Answers more detail:os...

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

0 votes

807 views

1 answer

postgresql - Postgres query to check a string is a number

Can anyone tell me the query to check whether a string is a number(double precision). It should return true ... Service' => should return false See Question&Answers more detail:os...

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

0 votes

724 views

1 answer

postgresql - Java JDBC ignores setFetchSize?

I'm using the following code st = connection.createStatement( ResultSet.CONCUR_READ_ONLY, ResultSet.FETCH_FORWARD, ResultSet. ... 8.3 server) See Question&Answers more detail:os...

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

0 votes

671 views

1 answer

postgresql - Test for null in function with varying parameters

I have a Postgres function: create function myfunction(integer, text, text, text, text, text, text) RETURNS table ... for NULL inside the query? See Question&Answers more detail:os...

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

0 votes

777 views

1 answer

postgresql - Multicolumn index on 3 fields with heterogenous data types

I have a postgres table with 3 fields: a : postgis geometry b : array varchar[] c : integer and I have a ... will use them all during the query? See Question&Answers more detail:os...

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

0 votes

706 views

1 answer

postgresql - Get most common value for each value of another column in SQL

I have a table like this: Column | Type | Modifiers ---------+------+----------- country | text ... there a more straight forward way to do it? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Spark Dataframes UPSERT to Postgres Table

I am using Apache Spark DataFrames to join two data sources and get the result as another DataFrame. I want to write ... am using Spark 1.6.0. See Question&Answers more detail:os...

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

0 votes

710 views

1 answer

postgresql - DROP FUNCTION without knowing the number/type of parameters?

I keep all my functions in a text file with 'CREATE OR REPLACE FUNCTION somefunction'. So if I add or change some ... to the top of my file? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags