Category "postgresql"

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