Category "postgresql"

Will TypeORM @AfterRemove or @BeforeRemove entity listeners still run when the db is dropped?

Some entities in my database have a property which is their associated key on AWS S3, for example: // my.entity.ts @Column() s3Key: string; I would like one of

recursive tree as a list (array items) in a new attribute value child

How to get hierarchy data(recursive tree) as a new column like below? (if there is last child then column child array is empty) rows: [{ 'id' : 1, 'paren

Printing to the screen in a .sql file in PostgreSQL

I have a .sql file I am building for an upgrade to my application that alters tables, inserts/updates, etc. I want to write to the screen after every command fi

Spark streaming jdbc read the stream as and when data comes - Data source jdbc does not support streamed reading

I am using PostGre as database. I want to capture one table data for each batch and convert it as parquet file and store in to s3. I tried to connect using JDB

Filter jsonb results in subselect

I'm building a hierarchical JSON result from several tables. These are just examples but should be sufficient for the purpose of this demonstration to get the i

Postgres backup as tar.gz

I'm trying to backup Postgres with pg_dump. pg_dump $POSTGRES_DB -U postgres > $POSTGRES_DB-$(date +%d-%m-%y_%H-%M).sql What is the way to backup it as tar.

Postgresql Multiple counts for one table

From two columns in my table I want to get a unified count for the values in these columns. As an example, two columns are: Table: reports | type

Copy a table from one database to another in Postgres

I am trying to copy an entire table from one database to another in Postgres. Any suggestions?

psql: command not found Mac

I installed PostgreSQL via the graphical install on http://www.postgresql.org/download/macosx/ I see it in my applications and also have the psql terminal in m

Postgres split timestamp column to time column and date column

Hi as the title says I have a column named healthtime in my table which is of type timestamp without timezone i.e. Healthime 2012-02-02 08:15:00 I would like

AWS RDS Postgres: WAL_LEVEL not set to 'logical' after changing rds.logical_replication = 1

I am in the process of setting up Debezium to work with AWS Aurora Postgres (postgres version 12.6). For Debezium to work, the WAL (Write-ahead-logging) must be

postgres LISTEN/NOTIFY rails

Ryan Bates mentions the LISTEN/NOTIFY functionality of Postgres when discussing push notifications in this episode, but I haven't been able to find any hint on

How to declare variable in PostgreSQL [duplicate]

I try to declare a variable in a code like this: DECLARE p_country VARCHAR; p_country : = ''; SELECT p_country; But it's doesn't work:

How to declare variable in PostgreSQL [duplicate]

I try to declare a variable in a code like this: DECLARE p_country VARCHAR; p_country : = ''; SELECT p_country; But it's doesn't work:

How to declare variable in PostgreSQL [duplicate]

I try to declare a variable in a code like this: DECLARE p_country VARCHAR; p_country : = ''; SELECT p_country; But it's doesn't work:

How to declare variable in PostgreSQL [duplicate]

I try to declare a variable in a code like this: DECLARE p_country VARCHAR; p_country : = ''; SELECT p_country; But it's doesn't work:

Other Categories