Recent questions tagged PostgreSQL

0 votes

1.1k views

1 answer

postgresql - Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql copy

I'm trying to import data from a .csv file into a postgresql 9.2 database using the psql COPY command (not ... What is wrong with the datestyle? See Question&Answers more detail:os...

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

0 votes

817 views

1 answer

postgresql - Do stored procedures run in database transaction in Postgres?

If a stored procedure fails in middle, are changes at that point from the beginning of SP rolled back ... in a database transaction only? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - ERROR: could not stat file "XX.csv": Unknown error

I run this command: COPY XXX FROM 'D:/XXX.csv' WITH (FORMAT CSV, HEADER TRUE, NULL 'NULL') In Windows 7, ... error How can I fix this issue? See Question&Answers more detail:os...

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

0 votes

807 views

1 answer

postgresql - plpgsql error "RETURN NEXT cannot have a parameter in function with OUT parameters" in table-returning function

I have a plpgsql function in PostgreSQL 9.2 which returns a table. The function runs several SELECTs that return the ... must be a better way. See Question&Answers more detail:os...

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

0 votes

652 views

1 answer

postgresql - Loading json data from a file into Postgres

I need to load data from multiple JSON files each having multiple records within them to a Postgres table. I am using ... ID":"System.Byte[]"}] See Question&Answers more detail:os...

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

0 votes

725 views

1 answer

postgresql - Postgres query optimization (forcing an index scan)

Below is my query. I am trying to get it to use an index scan, but it will only seq scan. By the way the ... ANY ('{cpu,mem}'::text[])) See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - Function with SQL query has no destination for result data

I am trying to create a function that returns a SELECTed resultset. When I call my postgres function like this ... What is the problem here? See Question&Answers more detail:os...

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

0 votes

862 views

1 answer

postgresql - Determining the OID of a table in Postgres 9.1?

Does anyone know how to find the OID of a table in Postgres 9.1? I am writing an update script that ... after the first from erroring out. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

postgresql - How to fix pg_dump version mismatch errors?

When trying to get local data to Heroku, I am encountering a version mismatch between two different versions of ... Mountain Lion 10.8.2. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - Insert Python Dictionary using Psycopg2

What is the best way to insert a Python dictionary with many keys into a Postgres database without having to enumerate ... ()) VALUES (song)') See Question&Answers more detail:os...

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

0 votes

928 views

1 answer

postgresql - How should I import data from CSV into a Postgres table using pgAdmin 3?

Is there any plugin or library which I need to use for this? I want to try this on my local system ... then do the same on Heroku Postgresql See Question&Answers more detail:os...

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

0 votes

813 views

1 answer

postgresql - postgres autoincrement not updated on explicit id inserts

I have the following table in postgres: CREATE TABLE "test" ( "id" serial NOT NULL PRIMARY KEY, "value" text ) I ... am not sure how to do that. See Question&Answers more detail:os...

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

0 votes

706 views

1 answer

postgresql - About clustered index in postgres

I'm using psql to access a postgres database. When viewing the metadata of a table, is there any way to see ... a clustered index, is it true? See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

postgresql - psql invalid command N while restore sql

I'm trying to restore my dump file, but it caused an error: psql:psit.sql:27485: invalid command N Is there a ... I didn't get a clear answer. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Postgres error on insert - ERROR: invalid byte sequence for encoding "UTF8": 0x00

I get the following error when inserting data from mysql into postgres. Do I have to manually remove all null ... for encoding "UTF8": 0x00 See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

postgresql - SQL update fields of one table from fields of another one

I have two tables: A [ID, column1, column2, column3] B [ID, column1, column2, column3, column4] A will ... accepted (however, not preferred). See Question&Answers more detail:os...

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

0 votes

700 views

1 answer

postgresql - Postgres: Distinct but only for one column

I have a table on pgsql with names (having more than 1 mio. rows), but I have also many duplicates. I ... do only a distinct on one column? See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

postgresql - input file appears to be a text format dump. Please use psql

I take backup using pg_dump db_production > postgres_db.dump and then I copy it to localhost using scp. ... -d db_development postgres_db.dump See Question&Answers more detail:os...

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

0 votes

845 views

1 answer

postgresql - Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib

I just installed posgresql with homebrew and when I go on to type the command psql I get the following error: ... any idea about what's wrong? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Connect to a heroku database with pgadmin

I would like to manage my Heroku database with pgadmin client. By now, I've been doing this with psql. When ... . How to achieve the connection? See Question&Answers more detail:os...

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

0 votes

840 views

1 answer

postgresql - Alternate output format for psql

I am using PostgreSQL 8.4 on Ubuntu. I have a table with columns c1 through cN. The columns are wide enough ... let me do something like that? See Question&Answers more detail:os...

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

0 votes

790 views

1 answer

postgresql - SQL INSERT without specifying columns. What happens?

Was looking through the beloved W3schools and found this page and actually learned something interesting. I didn' ... syntax even useful? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Heroku database restore issue

Have gone through different solutions available on stackoverflowand also on different forums. But none addresses the ... tables and data. See Question&Answers more detail:os...

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

0 votes

988 views

1 answer

postgresql - Orbeon Forms Postgres DB connection

I have tried to save the Orbeon forms in Postgres DB. I created data bases persistence layer but still forms ... orbeon forms in Postgres DB? See Question&Answers more detail:os...

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

0 votes

904 views

1 answer

postgresql - jsonb vs jsonb[] for multiple addresses for a customer

It's a good idea to save multiple addresses in a jsonb field in PostgreSQL. I'm new in nosql and I'd like to ... use jsonb[], how does it work? See Question&Answers more detail:os...

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

0 votes

781 views

1 answer

postgresql - Is there a way to disable updates/deletes but still allow triggers to perform them?

Basically, I want to be able to use the REVOKE command to disable UPDATE and DELETE, but I still want the ... TRIGGERS but disabling the rest? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - clojure.java.jdbc lazy query

I have a query that is basically a select *. In development this table is only 30000 rows, but in production it will ... )})) @row) ;;=> 300000 See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

postgresql - Why can I create a table with PRIMARY KEY on a nullable column?

The following code creates a table without raising any errors: CREATE TABLE test( ID INTEGER NULL, CONSTRAINT ... just failed right there? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags