Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b32cr-0007l1-LY for pgsql-admin@arkaria.postgresql.org; Wed, 18 May 2016 14:39:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b32cr-00035a-88 for pgsql-admin@arkaria.postgresql.org; Wed, 18 May 2016 14:39:05 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b32b8-0003jg-K8 for pgsql-admin@postgresql.org; Wed, 18 May 2016 14:37:18 +0000 Received: from 104-190-1-44.lightspeed.sndgca.sbcglobal.net ([104.190.1.44] helo=joeconway.com) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b32b5-0005c4-NX for pgsql-admin@postgresql.org; Wed, 18 May 2016 14:37:17 +0000 Received: from [137.122.64.8] (account jconway@joeconway.com HELO [10.65.211.122]) by joeconway.com (CommuniGate Pro SMTP 6.1.4) with ESMTPSA id 16469196; Wed, 18 May 2016 07:37:14 -0700 Subject: Re: Table symbolic link To: "Campbell, Lance" , "pgsql-admin@postgresql.org" References: From: Joe Conway Openpgp: id=4EA5B4659ED59CC9538139A5332B7E68B699434A Message-ID: <573C7E17.3020707@joeconway.com> Date: Wed, 18 May 2016 10:37:11 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.2 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="oIkgF8p3WwDtEAvEBmvf8ixPGmdLvN4FB" X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --oIkgF8p3WwDtEAvEBmvf8ixPGmdLvN4FB From: Joe Conway To: "Campbell, Lance" , "pgsql-admin@postgresql.org" Message-ID: <573C7E17.3020707@joeconway.com> Subject: Re: [ADMIN] Table symbolic link References: In-Reply-To: Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 On 05/18/2016 10:31 AM, Campbell, Lance wrote: > The better strategy would be to rename the table to the new name and add > a symbolic table that link to the new table name. Then as I make > changes to each application I can point them to the new name. Maybe in > a year I could delete the symbolic table name. >=20 > Is this possible? I have not seen a symbolic table name feature but I > thought I would ask. See CREATE VIEW: http://www.postgresql.org/docs/9.5/interactive/sql-createview.html HTH, Joe --=20 Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development --oIkgF8p3WwDtEAvEBmvf8ixPGmdLvN4FB Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iQIcBAEBAgAGBQJXPH4XAAoJEDfy90M199hlRukQAIHTxMMVlCbLzPtQW904ZQpY 3+5FWGZJiN7lkEzjh362qUch2OnOoba1TgPFL6N8jNRjpU7ak70P3LlW7jHx5chg cDQxWFuakQKTpUTYur9tX8iiyvkZcsQjUVeUcZCo0zJSHPYx8boexeL8HZzLoB17 M6YsNpPHFZJT2WtkgBWxnNeTnlaxWuC8T3sF96W4yRGmhdRCWY3oY3dmxCMru6hC SY95OcQw9On9rABy501VPMPOqaxdeh6KcU8C7/ytvFjfxRM2wHdmTwS3FkVLEkgZ iu91QKQHAez4cX9wXauavtLJyG42CFvjfJPU32sjl2CzUvTCYrXjcMYm/AmtX5Pt ifVmjp5qNHmx6A5WqK4d5MUJUNHmgTi0R4UCl6GznBFKmULH0aab5xz5tsmFs60q 3KPtLce1iFNoO8aWYa+0ngrMyiC+jzWyR3UTy4CcuxO41+zhJYXOEWvKzJbAq1R8 sgBu+y6iFx6c7gqKWcouyPc7C0t7EVroe5o7+FIX8zsCxFKM3pTKRQqjlI4gNwgR 101VRnqGw9T32fZ6CIYpxGgTUS9JmBBd6oiywSEabKEdNow6Y8LgCLm00yf1iahY DLI+pKG8yOejhDJC6jf4QYTapetmCi3wXzEUfvpnRbm+J/X+SwMSYJtYHNfUIO/4 fZRmdnhkeb/TYyBvirCv =9m5s -----END PGP SIGNATURE----- --oIkgF8p3WwDtEAvEBmvf8ixPGmdLvN4FB--