I am trying to migrate my database from ms sql server to PostgreSQL using python script . Before migrating the data, script needs to create required tables. I i
I have lots of background jobs that queue up the same query. I've been having a situation where they get stuck, and I'd like to kill the really long running que
I am trying to set up LDAP authentication with Postgres. I have user in my database with the same name as in AD and the following string in pg_hba.conf: host a
I'm in new this field. How do I manage the dynamic calculation with formulas and what steps to achieve the below output?. I have tables. Table 1 - Info_question
I'm using psql to check if a table exists in a given database. The command below works fine to return t for True or f for False: psql -U $user -d $db -t -c "SEL
Does PostgreSQL support Unique Lexicographically Sortable Identifier (ULID) generator out of the box? It seems not. Does anyone know the best
EDIT: I found a file at /config/database.js which is used to connect to sqlite in development. When I change the client name from sqlite to postgres, that's whe
I'm learning from Ben's Awad video: Fullstack React GraphQL TypeScript Tutorial. I ran into a problem with typescript. I don't understand why compiler thinks t
So I'm asked to do this query for a college project: SELECT l.city AS name, AVG((pr.ap_price::double precision * 7 - pr.weekly::doub
I have two tables one for post and one for likes. Post table stores all the post information. Likes table has 3 columns id, post_id user_id Now I need help to f
I get "aggregate function calls cannot be nested" error from PostgreSQL. I tried different bunch of things but could not solve. sum( case when sum(
I used pg_dump with the directory format (-d) to export a database containing more than a hundred tables. By comparing the .dat file for a table with its size i
I am trying to connect to a postgresql database through SSL. In the appsetting.json file, my connection string is "DefaultConnection": "Sslmode=Require;Sslrootc
Based on this documentation of Azure, there should be a Data encryption option under Security. But I don't see any option of Security. Is there a way to enable
I'm trying to connect to a Postgres database with SQLAlchemy. I've installed psycopg2. However, I get the error sqlalchemy.exc.NoSuchModuleError: Can't load plu
When I "chainlink node start", I get the error: "Cannot boot Chainlink: opening db: failed to open db: failed to connect to host=/private/tmp user=myname databa
I have unfortunately broken my old machine with postgres 8.3 on debian 6.0, I found a directory backup of postgresql database files, and i try to copy them on t
I know that in Oracle we can do something like select * from TABLE(DBMS_XPLAN.DISPLAY_CURSOR('$$SQL_ID')). But there is no sql id field in pg_cursors catalog. W
I have a table with a very simple schema: ( instrument varchar(20) not null, ts timestamp not null, price double precision
Command executed: g++ -I"C:\Program Files\Java\jdk-16.0.2\include" -I"C:\Program Files\Java\jdk-16.0.2\include\win32" -I"C:\Program Files\libpqxx\include\pqxx"