Questions tagged [postgresql]
PostgreSQL is an open-source, relational database management system (RDBMS) available for all major platforms, including Linux, UNIX, Windows and OS X. Mention your version of Postgres when asking questions. Consider dba.stackexchange.com for questions concerning the administration or advanced features.
postgresql
177,626
questions
0
votes
0
answers
19
views
Why two queries with very different EXPLAIN plan cost estimate run in the same time?
I am trying to optimize the index of my table table. For this I have created two indices index_a and index_b.
When I run EXPLAIN plan. The cost for index_a reads as:
Index Only Scan using index_a on ...
- 7,290
0
votes
0
answers
17
views
DB2 to Aurora PostgreSQL Migration issues with trailing spaces
We are migrating the data from DB2 LUW to Aurora PostgreSQL database using AWS DMS.
For few tables we have a column with data type varchar(22) and the value of the column could end up having ending ...
0
votes
0
answers
8
views
How to Properly Create the Data Architecture for a PERN Stack Application?
I'm building a web application using the PERN stack, and I'm looking for best practices on how to design the data architecture.
I just did a basic pernTODO in order to practice my postgressSQL skill a ...
- 67
0
votes
1
answer
23
views
In pgloader loading csv file and i want to skip a row from file if specific column value is null
Loading csv file in pgloader using load file and I want to skip rows based on column condition for example if specific column value is null then i want to skip that row
Not able to get the approach ...
0
votes
0
answers
13
views
Navicat 16 Backup Error: 'column d.datlastsysoid does not exist' for Postgres 15.4 Database [duplicate]
I am using Navicat 16 to back up my remote PostgreSQL database, which is running version 15.4. However, during the backup process, I encounter an error that reads:
[ERR] ERROR: column d.datlastsysoid ...
- 1
1
vote
1
answer
59
views
INSERT rows that were missing for the UPDATE
I want to write a query that, if I was using variables, would look something like (pseudocode)
records = SELECT * FROM table_1 WHERE id = x
numberOfRowsUpdated = UPDATE table_2 SET column_1 = y WHERE ...
- 95
1
vote
1
answer
46
views
How to modify a PHP class to accept PgSql\Result as an attribute
I need to find a way (if possible) to make a PHP class accept a PgSql\Result object as an attribute. PHP 8.1+ has migrated the pgsql result resource to the PgSQL\Result instance. In prior versions ...
- 31
-2
votes
0
answers
22
views
insert in to target table and avoid the rows with same set of column value from source to target [duplicate]
-- Create a temporary table with sample data
CREATE TEMPORARY TABLE temp_student (
roll_no INT,
name VARCHAR(50)
);
-- Insert some sample records into the temporary table
INSERT INTO ...
-1
votes
0
answers
26
views
Cannot connect to Postgres from my php/symfony application
I'm having issues connecting to any database from my php/symfony application
when I try to connect to pg_connect("host=localhost port=5432 dbname=dbname user=username"); the app just dies ...
- 9
-3
votes
0
answers
30
views
Where is the Postgres installer for Windows? [closed]
Stupid question, I know, but I can't find the download link
https://www.postgresql.org/download/
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
the first page takes you to the ...
- 49
0
votes
1
answer
24
views
Not able to connect to foreign server
I am getting following error on PostgreSQL:
SQL Error [08001]: ERROR: could not connect to server "regionaldb_server"
Detail: connection to server at "localhost" (127.0.0.1), ...
0
votes
1
answer
47
views
Selecting Rows By Specific Column Data in PostgreSQL
I'm trying to build a recipe finder app (PERN stack) like SuperCook but I ran into some problems with my postgres table.
Short description of the desired result. I'd like the user to select some ...
- 13
-1
votes
0
answers
16
views
Flutter and Supabase (SQL)
Can someone tell me how I can create a page in flutter with Supabase where people can create their own Community and edit the Community name and this name will be displayed on another page for people ...
0
votes
1
answer
37
views
Why AT TIME ZONE increases the hours?
In PostgreSQL, I'm trying to convert a hour to local time zone.
My machine has UTC as timezone
show timezone;
UTC
why these queries return different answers?
SELECT '2024-07-01 00:00:00' at time zone ...
- 24.4k
-1
votes
0
answers
38
views
Use EOF to execute multi-line command in PSQL
I'm trying to run a PostgreSQL anonymous block in psql in nohup mode and capture the log in an output file. I am trying to put the code inside EOF but I always get an error. Not sure how to implement ...
- 669