4:17 PM, Alban Hertroys wrote:
> > On 12 Jan 2021, at 20:54, Alex Williams valencesh...@protonmail.com wrote:
> > Hi Ingolf,
> > For comments in views, I create a unused CTE and put my comments there, e.g.
> > WITH v_comments AS (
> > SELECT 'this is my comment'
Hi Ingolf,
For comments in views, I create a unused CTE and put my comments there, e.g.
WITH v_comments AS (
SELECT 'this is my comment' AS comment
)
Alex
Sent with [ProtonMail](https://protonmail.com) Secure Email.
‐‐‐ Original Message ‐‐‐
On Thursday, January 7, 2021 11:19 AM, Markho
pg_default tablespace.
Thanks again to both of you!
Alex
(Just a note: The name of the actual DB / objects manually moved were renamed
for this public post)
Sent with ProtonMail Secure Email.
‐‐‐ Original Message ‐‐‐
On Monday, July 15, 2019 8:33 PM, Adrian Klaver
wrote:
> On 7/15
the queries I've used from various
sources like stackoverflow don't provide the correct named tablespace.
Thanks,
Alex
Sent with ProtonMail Secure Email.
‐‐‐ Original Message ‐‐‐
On Monday, July 15, 2019 3:22 PM, Adrian Klaver
wrote:
> On 7/15/19 11:35 AM, Alex Willia
Hi,
Server Version 9.5
I found this old thread on something similar to the results I'm getting:
https://www.postgresql.org/message-id/1308615192339-4508750.post%40n5.nabble.com
But in my case, I have a database that's in a user-defined tablespace (data2)
and all the tables/indexes there are al
ace = pg_default;" did it restore to the pg_default tablespace.
Thanks again for your help!
Sent with ProtonMail Secure Email.
‐‐‐ Original Message ‐‐‐
On Wednesday, July 10, 2019 10:20 AM, Tom Lane wrote:
> Ian Barwick ian.barw...@2ndquadrant.com writes:
>
> > On 7/10/19 2:
Hi,
Can someone point me in the right direction for this issue we are having -- our
goal is to dump a database that is currently on a tablespace named data2 that
we want to restore on the same server but on tablespace pg_default -- we tried
other ways like:
ALTER DATABASE "[database_name]" SET
