python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - psql

How to export a table in CSV format?

I have a logs table in the data base database. For the second day I'm struggling to upload it in CSV format. Commands like copy logs to 'D:/CSV.csv' WITH CSV DELIMITER ',' HEADER; don't help. The er...
test-img

3XTR4

python

postgresql

csv

psql

Votes: 0

Answers: 2

Latest Answer

Either you are connected to a different database, or the schema (public?) is not on your search_path. In the latter case, use COPY public.logs TO 'D:/CSV.csv' (FORMAT 'csv', DELIMITER ',', HEADER);
test-img

Laurenz Albe

PostgreSQL duplicate a user with same permission

I'm currently working on some project migrations and I want to create a single user in our New PostgreSQL with the same set of roles and permissions as the one in existing PostgreSQL. I have searched ...
test-img

Shreyas B

postgresql

psql

Votes: 0

Answers: 1

Latest Answer

That is not easy to do, because permissions are not stored on the user, but on the object: every table, view, function etc. knows which user has which permissions on it. So to copy the permissions of ...
test-img

Laurenz Albe

PostgreSQL: Use Constant in SQL Statement

I am storing binary data in a Postgres database that needs to be in many rows. In order to not pollute my setup sql files with the same text I was trying to define a constant and then use that constan...
test-img

Anti-Distinctlyminty

sql

postgresql

psql

Votes: 0

Answers: 4

Latest Answer

You need to use session variable and access the value in the variable by using the function current_setting() . Like this: postgres=# create table MyTable(id int, my_binary_file varchar(1000)); CREATE...
test-img

rajorshi

Docker PostgreSQL 12.3 how to debug failed transaction\ incomplete message

Im using PostgreSQL 12.3 docker image, and i have an application that stopped working as some query transaction gets closed or incomplete in the middle of it and the application just doesn't work. My ...
test-img

gsr

sql

database

postgresql

transactions

psql

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs