I can restore a whole db using shell commands like sudo -u postgres psql -c "DROP DATABASE mynewdbname with (FORCE);" sudo -u postgres psql -c "CREATE DATABASE mynewdbname;" sudo -u postgres pg_restore -d mynewdbname /home/user/restore_20230824.sql -v Than I need to…
I recently setup an instance of Airbyte on my local machine using a Docker container. I also have a local instance of Postgres running which I would like to use as a data source in Airbyte. It seems like I…
E1 E2 E3 EXPLANATION AMOUNT 01 PERSONNEL EXPENSES 5000 01 1 OFFICERS 5000 01 1 1 BASIC SALARIES 3000 01 1 2 INCREASES AND COMPENSATION 2000 02 GOODS AND SERVICES PURCHASE EXPENSES 8000 02 1 SERVICE PROCUREMENT 8000 02 1…
Please help! I have a project using Sequelize, postgres and postgis (for gps). The schema (simplified) is: export default class Activity extends Model { static init(sequelize) { return super.init({ sequelize, tableName: 'activities', }) } static get modelAttributes() { return {…
When importing a csv file that contains strings with special characters into a varchar column in a table in a Postgresql database, I notice that the registered trademark symbols (®) and em dashes (—) are both getting stored as �.…
I have tried to select a list of databases and select all tables from each database, ordering the first ten tables by their size - including their indexes- through PL/pgSQL, but I have had a problem to join the query…
I have set up a decorator to provide my db connection using psycopg3 and I sometimes have it passing a connection that is closed and throwing the following error when I try to use it: the connection is closed Here…
I am trying to write a SQL query to get the month end prices for a particular instrument. Table (contains some other columns that can be ignored): instrumentId unitPrice reportedAt 1 90.22 2018-10-28 1 80.55 2018-10-30 1 70.55 2018-09-15 1…
I want to ask you it is possible to unique fields when a column is 1 ? I have a table sales defined like this: CREATE TABLE sales ( id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, p_id UUID REFERENCES…
I need a query which will display top 7 users by the total indicator of reviews written and ratings given, indicating the total number of pages in the books to which they reviewed Structure of 3 tables given: Books: book_id,…