ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
I have postgres database. I want the list of users with access privileges they are being assigned. I tried to find query and also looked in to psql command line help. (\nu and all) but I haven't found any usefull information. Is anyone knows about that can help me out. Thanks.
The same project needs to behave consistently on developer machines, in CI and after deployment. Which versions, dependencies and configuration should be recorded?
I'm having trouble working with Entity Framework and PostgreSQL, does anybody know how to join two tables and use the second table as a where clause? The select I want to do in Entity Framework would be in SQL: SELECT ai.id, ai.title, ai.description, ai.coverimageurl FROM app_information ai INNER JOIN app_languages al on al.id = ai.languageid WHERE al.langua
This seems like such a simple question to answer, but finding an answer for this seems impossible. I am building a password reset feature for a backend application with Express and Typescript. I am using Postgres for the database and Typeorm for data manipulation. I have a User entity with these two columns in my database: @Column({ unique: true, nullable: t
I try to import some files to a PostgreSQL database but I get this error: Falha Importar: SET SET SET SET SET set_config ------------ (1 row) SET SET SET SET SET Import error: exit status 3 ERROR: unrecognized configuration parameter "default_table_access_method"
I'm trying (for hours now) to install the cargo crate diesel_cli for postgres. However, every time I run the recommended cargo command: cargo install diesel_cli --no-default-features --features postgres I wait a few minutes just to see the same build fail with this message: note: LINK : fatal error LNK1181: cannot open input file 'libpq.lib' error: aborting
MongodDB 5.0 comes with support for time series https://docs.mongodb.com/manual/core/timeseries-collections/ I wonder, what is status with PostgreSQL support for time series? I could quickly find TimescaleDB https://github.com/timescale/timescaledb , that is actually open source extension for PostgreSQL. and detailed PostreSQL usage example from AWS https://
I need to map two columns of entity class as json in postgres using spring data jpa. After reading multiple stackoverflow posts and baeldung post , How to map a map JSON column to Java Object with JPA https://www.baeldung.com/hibernate-persist-json-object I did configuration as below. However, I am facing error " ERROR: column "headers" is of type json but e
I am trying to get soft deleted doc from postgreSQL database using typeorm find, findOne or query builder get/getMany methods, but it always return undefined. Is there a way to get deleted value? By the docs it should only set a timestamp for deletedAt , and it definitely works, because I can update same record using update where from query builder.
express
typescript
rust
json
liquibase