All Questions
Tagged with command-line postgresql
3 questions
0
votes
1
answer
362
views
Running psql with a role
When using psql I always have to issue set role ... first.
Could this be executed automatically before accepting interactive commands?
E.g.:
psql -h HOST -U USER -c "set role 'ROLE';" -f -
...
1
vote
1
answer
1k
views
How do I time how long my pg_restore takes in the command line?
I'm trying to track the amount of time the process takes for when I move around my data and upgrade my web app. From the command line, how would I track the amount of time elapsed from when the ...
-1
votes
1
answer
548
views
Postgres 9.0 linux command to windows command conversion [closed]
i am working on an application using delphi 7 as the front end and postgres 9.0 as the back end.
I have to upload images to the server so i use \lo_import and \lo_export for inserting images on the ...