I am encountering an error while attempting to use the Postgres FDW extension to import a foreign schema from the same database server for performing join queries. Below, I have provided a snapshot of my pgAdmin for better clarity, along…
I am using FastAPI framework and writing some data into PostgreSQL database. The issue I am encountering is that I have a function get_current_user() that returns user credentials (including email), but I am not sure how to access this data…
I have a table called fund_flag and it has columns like fund_type, fund1, fund2, fund3, fund4, fund5, fund6, sign_val and table data is as follows. fund_type fund1 fund2 fund3 fund4 fund5 fund6 sign_val SGP Y N N N Y N…
I'm an SQL novice, I have a big data table with attributes exceeding 10000 columns which is hosted by CSV, and those columns come from multiple sites, I tried to import them into a database to manage them due to…
I have a Django model representing a website, and I use the Postgres Full Text Search to search the Website objects. However, if you search for only part of a website's url, it doesn't return matching Websites. e.g. if a…
I am looking for Postgresql Query to implement something like this. I have to distinctly divide employee table on base of week and then get count of employees added on the a week days. Example :: Week | Sunday |…
I am trying to add a unique constraint to an existing table in Postgres on a null column named personnel_id. Most of the records have null personnel_id. Here's how I do it: ALTER TABLE "myschema"."mytable" ADD UNIQUE NULLS not distinct…
I have this postgres query that is validating if the columns are null or not based on one codition, this is a normal query that is not requiring function, could be overkill a functional approach because this is unique scenario…
I run the below query concurrently in pgAdmin to see how SELECT FOR UPDATE run. The logic is that there will be a limit for number of users for each team. And if the number reach the limit, the insert…
I can't figure out how to get a list of scalar functions in a postgres database. I've tried to write different queries, but I can't find an exact solution to determine the scalar type returned by a function. So far…