Re: [google-cloud-sql-discuss] Why don't my tables show up for other users?

Hi Matthew,

Please make sure you connect to the same database. Usually PostgreSQL clients will connect to the same database name as username by default. I.e. if you don't specify database name, user 'postgres' will connect to 'postgres', and 'otheruser' will connect to different, 'otheruser' database.

Also, make sure new user has permissions to access objects created by 'postgres'.  Please follow official PostgreSQL documentation when checking this, e.g. https://www.postgresql.org/docs/9.6/static/ddl-priv.html and related pages, as well as pointers from CloudSQL documentation: https://cloud.google.com/sql/docs/postgres/users

--
Vladimir Rusinov
PostgreSQL SRE, Google Ireland

Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland
Registered in Dublin, Ireland
Registration Number: 368047

On Tue, Oct 10, 2017 at 2:35 PM, Matthew Speck <mjohnspeck@gmail.com> wrote:

Hi all, I recently created a Google Cloud PostgreSQL instance and uploaded several datasets using the df.to_sql() Pandas command in Python. I uploaded them over a SQLAlchemy connection using the default 'postgres' user that is created whenever you start a SQL instance on GCP. I then created a second user, but when I connect using the second user, I do not see any of the tables I previously uploaded. If I disconnect and reconnect using the 'postgres' user, all the tables are still there. Can anyone tell me why the tables are showing up for the default account but not the second account? And how I can fix this?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f972bd10-c13b-442a-b3fb-c74ec5ce1c33%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAE1wr-yGpq5WhZ%3D9M4a-hxWTAdf3oTieQyynWbdq5xqAa5QAGQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.