Обсуждение: pgAdmin 4 - How to I import a .sql file?

Поиск
Список
Период
Сортировка

pgAdmin 4 - How to I import a .sql file?

От
velvetpixel
Дата:
Postgres and pgAdmin newbie.

I have a new empty postgres database on my server. I can see it in pgAdmin
4.

I have a .sql file I would like to import to populate that DB with tables
and data.

I see no way to do that in pgAdmin 4



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: pgAdmin 4 - How to I import a .sql file?

От
Melvin Davidson
Дата:
I am not PgAdmin4 support, but you can:
1. Open/select the database in PgAdmin4
2. In the top menu, Click Tools, Query Tool
3. Click the left most icon in Query Tool and drill down to find the .sql file
you want.
4. Click Select
5. To run, Click the lightning icon (to the right of "No Limit".

Melvin Davidson 🎸
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com



On Thursday, January 4, 2018, 11:45:25 AM EST, velvetpixel <velvetpixel@gmail.com> wrote:


Postgres and pgAdmin newbie.

I have a new empty postgres database on my server. I can see it in pgAdmin
4.

I have a .sql file I would like to import to populate that DB with tables
and data.

I see no way to do that in pgAdmin 4



--

Re: pgAdmin 4 - How to I import a .sql file?

От
Raymond O'Donnell
Дата:
On 04/01/18 16:11, velvetpixel wrote:
> Postgres and pgAdmin newbie.
> 
> I have a new empty postgres database on my server. I can see it in pgAdmin
> 4.
> 
> I have a .sql file I would like to import to populate that DB with tables
> and data.

Open a query window (Tools -> Query Tool), then you can open your SQL 
file and run it there (see the toolbar on the query window).

HTH,

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Re: pgAdmin 4 - How to I import a .sql file?

От
velvetpixel
Дата:
Perfect!

Thanks Melvin :)



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html