python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - pg

How to take pg dump from testing server to my pc

I am trying to take pg dump from testing server to my local machine, i have been logged into my server root@myproject-staging-development1:~/myproject/current# Which command should i write in here to ...
test-img

Azhar Sheikh

ruby-on-rails

postgresql

ubuntu

pg

pg-dump

Votes: 0

Answers: 2

Latest Answer

Dump Your PostgreSQL Database Step 1 SSH to the staging/production server. Step 2 Dump the desired database: pg_dump database_name > database_name_20160527.sql You can name your dump as you wish -...
test-img

felunka

TypeScript: postgres column doesn't exist

I am using pg library to make query on postgres by typeScript. I have created a db class like this: import { Pool } from 'pg'; const pool = new Pool({ host: process.env.PG_HOST, port: parseI...
test-img

Cyrus the Great

typescript

postgresql

pg

Votes: 0

Answers: 1

Latest Answer

Try the following as your query: SELECT email FROM "User" LIMIT 10 You need to quote the table name if you did it when creating the table.
test-img

Islingre

Why does PG timestamp give incorrect result?

Why Select timestamptz '2022-03-19T00:00Z' as test1 give result : 2022-03-19 03:00:00+03 ??
test-img

Disteonne

postgresql

timestamp

pg

Votes: 0

Answers: 1

Latest Answer

You're indicating Postgresql a timestamptz at UTC time. There, it's returning a strictly equivalent time, except it is displayed in a different time zone (UTC-03). Why does Postgresql not return the e...
test-img

Clej

GO pg prevent default value

Struct sample type Car struct { ID uint64 Required bool `pg:"required,notnull"` Name string `pg:"name"`...
test-img

kyrkela

go

pg

Votes: 0

Answers: 1

Latest Answer

Because the value false will be read as a null value. Because null value your data will be change to the default value (TRUE) You must change the struct to like this type Car struct { ID uin...
test-img

Abdul Hamid

Posts

Questions

Blogs

Jobs