Re: How to execute .sql file inside a postgres schema

From: "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com>
To: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to execute .sql file inside a postgres schema
Date: 2019-04-29 14:52:10
Message-ID: AM6PR09MB31562542DA40553484620216D2390@AM6PR09MB3156.eurprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>I have a database name “kbdb” that is having a schema “kb” and I want to execute the test.sql file inside >>this schema,

set schema 'your_schema';

Cheers,

Daniel

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Philippe Chenel 2019-04-29 16:58:37 RE: 9.6.9 Default configuration for a default installation but different with-krb-srvnam
Previous Message rihad 2019-04-29 14:45:48 Upgrading locale issues