Recent questions tagged PostgreSQL

0 votes

779 views

1 answer

postgresql - SQL query for index/primary key ordinal

In our on-line contest system, there is a frequently changing table standings with integer columns (user_id, score ... result of this question. See Question&Answers more detail:os...

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

0 votes

732 views

1 answer

postgresql - Join Alias Columns SQL

I am trying struggling with joining alias named columns. Overall, I want an output with the with date, hour, ... timestmp, station, lat, lon) See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

postgresql - Running SQL script through psql gives syntax errors that don't occur in PgAdmin

I have the following script to create a table: -- Create State table. DROP TABLE IF EXISTS "State" CASCADE; ... using psql and not with pgAdmin? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - How to count days except Sundays between two dates in Postgres?

To find the number of days between two dates we can use something like this: SELECT date_part('day',age('2017 ... Total Days except Sundays = 26 See Question&Answers more detail:os...

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

0 votes

585 views

1 answer

postgresql - Database design - should I use 30 columns or 1 column with all data in form of JSON/XML?

I am doing a project which need to store 30 distinct fields for a business logic which later will be used ... this saving effort worth doing ? See Question&Answers more detail:os...

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

0 votes

969 views

1 answer

postgresql - Find rows where text array contains value similar to input

I'm trying to get rows where a column of type text[] contains a value similar to some user input. What I' ... if it is possible in WHERE clause? See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

postgresql - Read data from a text file inside a trigger

Is there any way by which data on an text file can be accessed inside a trigger function? See Question&Answers more detail:os...

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

0 votes

627 views

1 answer

postgresql - Use text output from a function as new query

In continuing from a previous case that was assisted by @Erwin Brandstetter and @Craig Ringer, I have fixed my code to ... FETCH ALL IN "roy"; See Question&Answers more detail:os...

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

0 votes

696 views

1 answer

postgresql - Postgres: "vacuum" command does not clean up dead tuples

We have a postgres database in Amazon RDS. Initially, we needed to load large amount of data quickly, so ... options, restart the instance? See Question&Answers more detail:os...

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

0 votes

898 views

1 answer

postgresql - Cannot update view?

My site was developed using Drupal 6 running on a Postgresql 8.3 server on Ubuntu 11.10. Also webmin version ... A syntax error? Something else? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

postgresql - Java Crosstab - preparedstatement query

I have a typical crosstab query with static parameters. It works fine with createStatement. I want to use ... what I am missing? See Question&Answers more detail:os...

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

0 votes

788 views

1 answer

postgresql - Apache Spark : JDBC connection not working

I have asked this question previously also but did not got any answer (Not able to connect to postgres using ... .Thread.run(Thread.java:619) 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 select 1d array from 2d array?

I have 2d array and want to select only first element of it, which is 1d array. How do I do that? See Question&Answers more detail:os...

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

0 votes

714 views

1 answer

postgresql - Migrating from Postgres to SQL Server 2008

I need to migrate a database from Postgres 7 to SQL Server 2008. I am familiar with the SSIS Import and ... data sources/drivers for postgres? See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

postgresql - How to ignore errors with psql copy meta-command

I am using psql with a PostgreSQL database and the following copy command: COPY isa (np1, np2, sentence) FROM ... I skip the lines with errors? See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

postgresql - Where do I get libpq source?

I want to write application which uses Postgresql as DBMS. To write client application do I need libpq library ... library and header files. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Docker-compose with django could not translate host name "db" to address: Name or service not known

I have currently a system built with docker-compose, it creates a Django application. Up until now I've used ... message. I am completely lost. See Question&Answers more detail:os...

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

0 votes

813 views

1 answer

postgresql - Trigger vs. check constraint

I want to add a field-level validation on a table. There is a field named "account_number" and this field ... questions for the dba board. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Postgres UNIQUE CONSTRAINT for array

How to create a constraint on the uniqueness of all the values ??in the array like: CREATE TABLE mytable ... check under the UNIQUE CONSTRAINT See Question&Answers more detail:os...

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

0 votes

818 views

1 answer

postgresql - How can I generate a unique string per record in a table in Postgres?

Say I have a table like posts, which has typical columns like id, body, created_at. I'd like to generate ... -enforcing code in my application. See Question&Answers more detail:os...

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

0 votes

876 views

1 answer

postgresql - Django fixture fails, stating "DatabaseError: value too long for type character varying(50)"

I have a fixture (json) which loads in development environment but fails to do so in server environment. The ... in the dev environment.. See Question&Answers more detail:os...

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

0 votes

601 views

1 answer

postgresql - Calculate number of concurrent events in SQL

I have a table that holds phone calls, with the following fields: ID STARTTIME ENDTIME STATUS CALL_FROM CALL_TO ... on calls_nov (endtime); See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

postgresql - Copy schema and create new schema with different name in the same data base

I there a way to copy the existing schema and generate new schema with another name in the same database in postgres. See Question&Answers more detail:os...

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

0 votes

760 views

1 answer

postgresql - Is it possible to change the natural order of columns in Postgres?

Is it possible to change the natural order of columns in Postgres 8.1? I know that you shouldn't rely on column ... and out to the front end. See Question&Answers more detail:os...

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

0 votes

766 views

1 answer

postgresql - Slick 2.0 Generic CRUD operations

I've been looking around on how to implement a generic trait for commons CRUD and other kinds of operations, I ... Option[String]]("name") } See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Difference between DECIMAL and NUMERIC datatype in PSQL

what is the use of decimal and numeric datatype in postgreSQL. As per the reference the following is the ... example is much appreciated... See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

postgresql - Get the last N rows in the database in order?

Let's say I have the following database table: record_id | record_date | record_value -----------+---------- ... 5; So how do I accomplish this? See Question&Answers more detail:os...

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

0 votes

622 views

1 answer

postgresql - foreach %dopar% + RPostgreSQL

I am using RPostgreSQL to connect to a local database. The setup works just fine on my Linux machine. R 2.11 ... a method for function 'fetch'" See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags