Recent questions tagged PostgreSQL

0 votes

994 views

1 answer

postgresql - Get a timestamp from concatenating day and time columns

I am having day and time fields in database. I want to get the time-stamp by concatenating the day and time. How to do ... ' || Time)) > (e... See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Deferrable, case-insensitive unique constraint

Is it possible in PostgreSQL to create a deferrable unique constraint on a character column, but case- ... way around this limitation? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - LAST_DAY function in postgres

Is there any function(s) in postgres equivalent to Oracle function LAST_DAY(). I need to get last day in postgres (including month and year) See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - Psycopg2 Python SSL Support is not compiled in

I am trying to connect to my postgres database using psycopg2 with sslmode='required' param; however, I get the ... one that which python shows 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 Npgsql Connection Pooling

I'd like to better understand Connection Pooling when using Npgsql for Postgres. (http://www.npgsql.org/) ... would be appreciated. Thanks. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Selecting records between two timestamps

I am converting an Unix script with a SQL transact command to a PostgreSQL command. I have a table with records ... discuss that in my answer. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Check return status of psql command in unix shell scripting

I am using psql command to connect and issue a query on postgreSQL database. Can anybody let me know how to ... zero. Thanks for the help. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - String concatenation with a null seems to nullify the entire string - is that desired behavior in Postgres?

In Postgres: select 'test' || null returns null I was expecting it would otherwise return 'test'. Is this ... something that should be fixed? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - Library not loaded: /usr/local/lib/libpq.5.4.dylib

I am working on a rails app. Installed Postgresql using postgresql-9.1.2-1-osx.dmg Installed pg gem. Then ... for this. Advice anyone please? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - Check if a table column exists in the database using SQLAlchemy and Alembic

I'm using Alembic as migration tool and I'm launching the following pseudo script on an already updated ... exists before op.add_column. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Sql recursion without recursion

I have four tables create table entities{ integer id; string name; } create table users{ integer id;//fk ... result have a better performance. 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 set UTF-8 in PDO class constructor for PHP PgSQL database

I want to set UTF8 for my PDO object. This class works correctly with MySQL. I can't find an analog of array(PDO:: ... => "SET NAMES UTF8") ); } See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

postgresql - What is the difference between prepared statements and SQL or PL/pgSQL functions, in terms of their purpose?

In PostgreSQL, what is the difference between a prepared statement and a SQL or PL/pgSQL function, in terms of their ... fooplan(3, 'ben'); See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Where Postgres database files are saved in ubuntu?

How can I find where Postgres 8.x database files are saved in Ubuntu 10.04 file system? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

postgresql - SELECT .. INTO to create a table in PL/pgSQL

I want to use SELECT INTO to make a temporary table in one of my functions. SELECT INTO works in SQL but ... automatically like it does in SQL. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Auto-truncating fields at max_length in Django CharFields

I have a field that has a max_length set. When I save a model instance, and the field's value is greater than ... there must be a better way. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

postgresql - CREATE DATABASE cannot run inside a transaction block

I am working on AWS server + PostgreSQL. When I execute a query for creating the database I get an error: ... How can I resolve this issue? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - GitHub Actions: How to connect to Postgres in GithHub Actions

I am trying GitHub Actions for CI with a Ruby on Rails application. My setup is with VM, not running the Ruby build ... ] %> test: <<: *default See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

postgresql - Dropping column in Postgres on a large dataset

So I have a table with a large dataset and this table has a three columns that I would like to drop. ... any related questions / articles ... 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 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.3k 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 - 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.3k views

1 answer

postgresql - SELECT .. INTO to create a table in PL/pgSQL

I want to use SELECT INTO to make a temporary table in one of my functions. SELECT INTO works in SQL but ... automatically like it does in SQL. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

postgresql - Auto-truncating fields at max_length in Django CharFields

I have a field that has a max_length set. When I save a model instance, and the field's value is greater than ... there must be a better way. See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

postgresql - CREATE DATABASE cannot run inside a transaction block

I am working on AWS server + PostgreSQL. When I execute a query for creating the database I get an error: ... How can I resolve this issue? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - GitHub Actions: How to connect to Postgres in GithHub Actions

I am trying GitHub Actions for CI with a Ruby on Rails application. My setup is with VM, not running the Ruby build ... ] %> test: <<: *default See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

postgresql - Dropping column in Postgres on a large dataset

So I have a table with a large dataset and this table has a three columns that I would like to drop. ... any related questions / articles ... See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags