Re: [GENERAL] creating tables in tablespace

2017-08-24 Thread Tiffany Thang
-++-- postgrestab | postgres | mytablespace (1 row) Thanks. On Thu, Aug 24, 2017 at 2:46 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Tiffany Thang <tiffanyth...@gmail.com> writes: > > According to the documentation, a table can be created in a specific > &g

[GENERAL] creating tables in tablespace

2017-08-24 Thread Tiffany Thang
Hi, I'm not able to create tables in a specific tablespace. I'm not sure what I have missed. According to the documentation, a table can be created in a specific tablespace by performing the following: 1. Specify the tablespace parameter in the create database statement. 2. Specify the tablespace

Re: [GENERAL] Developer GUI tools for PostgreSQL

2017-07-27 Thread Tiffany Thang
Thanks everyone for your input! On Thu, Jul 27, 2017 at 3:48 AM, Thore Boedecker <m...@foxxx0.de> wrote: > On 26.07.17 - 18:41, Tiffany Thang wrote: > > Hi, > > I'm new to PostgreSQL. I'm looking for a developer tool that works > > similarly to TOAD or SQL Developer f

[GENERAL] Developer GUI tools for PostgreSQL

2017-07-26 Thread Tiffany Thang
Hi, I'm new to PostgreSQL. I'm looking for a developer tool that works similarly to TOAD or SQL Developer for Oracle/MySQL which would allow me to view and make DDL changes to database objects and create data models. It would be a plus if I can use the same tool to perform some database