N
N
NataliaOxford2019-11-10 13:20:48
css
NataliaOxford, 2019-11-10 13:20:48

How can I import a database into PostgreSQL?

Hello! I'm trying to import a database that does not specify a file type using the command:
copy "table" from 'C:\sd\BD'
It gives the following error:
ERROR: ERROR: unable to open file "C:\z\DB_com" for reading : No such file or directory
HINT: COPY FROM tells the PostgreSQL server process to read data from a file. Perhaps what you really need is a client facility, such as psql's \copy.

Answer the question

In order to leave comments, you need to log in

4 answer(s)
N
Nikita Cheremisin, 2018-10-16
@unlik

flex, justify-content: space-between;

A
azaza, 2018-10-16
@natojezlo

<form class="mainform">
<input placeholder="Имя*">
<input placeholder="Email*">
<br class="clear"/>
<textarea placeholder="Ваше сообщение*"></textarea>
</form>

*{box-sizing:border-box;}
.mainform input{width:49%; float:left; margin:1%; padding:5px 10px;}
.mainform textarea{width:100%; padding:5px 10px; margin:1%;}

}

I would advise you to do it on the GRID, but it’s a waste to write something

P
Pashchuk Ilya, 2018-10-16
@IlyaDeveloper

like this bro:
https://jsfiddle.net/74enouhz/1/

<form class="form">
  <input class="input" placeholder="Name"></inpu>
    <input class="input"  placeholder="Email"></inpu>
    <textarea class="textarea"  placeholder="Message" name="" id="" cols="30" rows="10"></textarea>
</div>

.form {
  display: flex;
  flex-flow: row wrap;
  justify-content: space-between;

  padding: 10px;

  background-color: #f6f6f6;

  box-sizing: border-box;
}

.input {
  display: inline-block;
  
  width: calc(50% - 26px);

  margin: 10px;

  border: 2px solid #f24f1d;
}

.textarea {
  flex: 1 1 100%;

  margin: 10px;
}

K
ky0, 2019-11-10
@ky0

You are trying to import a table from a file. It's not done that way.
If this is a text dump, then you need to use psql -f . If binary, use pg_restore .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question