Postgres database.table notation

Question

Im trying to alter a table ALTER TABLE database.table...

What is the correct notation to access tables in a DB from the base postgres db without having to explicitly connect to that database?

Postgres is not MySQL where a database is actually a schema. A database in Postgres is a separate global object that can only be operated on by connecting to it. If you want to do this in Postgres then emulate MySQL by separating objects into schema's. — Adrian Klaver
– Adrian Klaver, Commented May 30, 2022 at 0:07

Erwin Brandstetter · Accepted Answer · 2022-05-29 23:15:30Z

1

There is no way. You have to connect to the right database.

answered May 29, 2022 at 23:15

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Frank Heikens · Accepted Answer · 2022-05-30 07:22:05Z

A DATABASE within MySQL is comparable with a SCHEMA in PostgreSQL and many other brands.

MySQL: ALTER TABLE database.table... Others: ALTER TABLE schema.table...

From the MySQL manual:

CREATE SCHEMA is a synonym for CREATE DATABASE.

This actually means that a single MySQL server has just a single database. This database can have many schema's and every schema can have many tables.

Within a single database you can jump from one schema to the other schema, no problem. This works for MySQL, PostgreSQL and many others. You can not jump from one database to another database without a new database connection because it's a different instance.

It is that MySQL uses a different name for a schema, it calls this a database. A little confusing.

If you want the same thing in other databases, like PostgreSQL, just use schema's within a single database.

Collectives™ on Stack Overflow

Postgres database.table notation

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related