Thanks David and Achilleas. This is no longer an issue. The table
previously went to the public schema. I'm not sure what I did. Anyway,
without a prefix, it defaults to the current schema.
On Thu, Mar 8, 2018 at 2:02 AM, Achilleas Mantzios <
ach...@matrix.gatewaynet.com> wrote:
> On 08/03/2018 0
On 08/03/2018 01:13, David G. Johnston wrote:
On Wed, Mar 7, 2018 at 4:05 PM, Tiffany Thang mailto:tiffanyth...@gmail.com>>wrote:
The search_path configuration works only for queries.
Um
https://www.postgresql.org/docs/10/static/sql-createschema.html
"A CREATE command specif
On Wed, Mar 7, 2018 at 4:05 PM, Tiffany Thang
wrote:
>
> The search_path configuration works only for queries.
>
Um
https://www.postgresql.org/docs/10/static/sql-createschema.html
"A CREATE command specifying an unqualified object name creates the object
in the current schema (the one
Hi,
Would it be possible to create a table or index in a schema without
prefixing the schema name? I find it a hassle to keep specifying the schema
name when I create an object or performing DMLs in a schema. The
search_path configuration works only for queries.
For example:
Is there a way to run
