Sfrgttk

UK: Is there precedent for the governments e-petition site changing the direction of a government decision?

Infinite Abelian subgroup of infinite non Abelian group example

Why is Collection not simply treated as Collection<?>

Watching something be written to a file live with tail

Can I use a neutral wire from another outlet to repair a broken neutral?

Doing something right before you need it - expression for this?

prove that the matrix A is diagonalizable

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

What reasons are there for a Capitalist to oppose a 100% inheritance tax?

How much of data wrangling is a data scientist's job?

Does casting Light, or a similar spell, have any effect when the caster is swallowed by a monster?

Blender 2.8 I can't see vertices, edges or faces in edit mode

Did converts (ger tzedek) in ancient Israel own land?

Fully-Firstable Anagram Sets

How could indestructible materials be used in power generation?

AES: Why is it a good practice to use only the first 16bytes of a hash for encryption?

How to take photos in burst mode, without vibration?

Has there ever been an airliner design involving reducing generator load by installing solar panels?

Withdrawals from HSA

How to draw the figure with four pentagons?

Took a trip to a parallel universe, need help deciphering

Will google still index a page if I use a $_SESSION variable?

Facing a paradox: Earnshaw's theorem in one dimension

1960's book about a plague that kills all white people

Table missing when using python to connect to postgres Google Cloud SQL instance

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

When using the python libraries (psycopg2, sqlalchemy) to connect to a postgres Cloud SQL instance I can't find the only table in my database. The cloud_sql_proxy notifies me that there is a connection going on and I get no errors when connecting to the database. The tables are just nowhere to be found.

This only happens when connecting through code. I can find the table when using the psql command line interface and the JDBC socket factory.

I followed the instructions on Connecting to Cloud SQL from external applications here. And I have tried using both libraries, both Unix and TCP and both production and local environments. All of these 8 combinations result in the same behavior.

Is this a problem with the python libraries? Is it a matter of user permissions? (There is only one database user which I used to create the table and populate it with data) Is there a configuration I'm missing in either of those fronts?

postgresql permissions table google-cloud-sql

share

asked 16 secs ago

Fernando LimaFernando Lima

11

New contributor

Fernando Lima is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

When using the python libraries (psycopg2, sqlalchemy) to connect to a postgres Cloud SQL instance I can't find the only table in my database. The cloud_sql_proxy notifies me that there is a connection going on and I get no errors when connecting to the database. The tables are just nowhere to be found.

This only happens when connecting through code. I can find the table when using the psql command line interface and the JDBC socket factory.

I followed the instructions on Connecting to Cloud SQL from external applications here. And I have tried using both libraries, both Unix and TCP and both production and local environments. All of these 8 combinations result in the same behavior.

Is this a problem with the python libraries? Is it a matter of user permissions? (There is only one database user which I used to create the table and populate it with data) Is there a configuration I'm missing in either of those fronts?

postgresql permissions table google-cloud-sql

share

asked 16 secs ago

Fernando LimaFernando Lima

11

New contributor

Fernando Lima is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

When using the python libraries (psycopg2, sqlalchemy) to connect to a postgres Cloud SQL instance I can't find the only table in my database. The cloud_sql_proxy notifies me that there is a connection going on and I get no errors when connecting to the database. The tables are just nowhere to be found.

This only happens when connecting through code. I can find the table when using the psql command line interface and the JDBC socket factory.

I followed the instructions on Connecting to Cloud SQL from external applications here. And I have tried using both libraries, both Unix and TCP and both production and local environments. All of these 8 combinations result in the same behavior.

Is this a problem with the python libraries? Is it a matter of user permissions? (There is only one database user which I used to create the table and populate it with data) Is there a configuration I'm missing in either of those fronts?

postgresql permissions table google-cloud-sql

share

asked 16 secs ago

Fernando LimaFernando Lima

11

New contributor

Fernando Lima is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 16 secs ago

Fernando LimaFernando Lima

11

New contributor

Fernando Lima is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 16 secs ago

Fernando LimaFernando Lima

11

New contributor

Fernando Lima is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 16 secs ago

Fernando LimaFernando Lima

11

New contributor

Fernando Lima is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 16 secs ago

Fernando LimaFernando Lima

11