![]() ![]() If you’re using a good visual interface to PostgreSQL, browsing the schema can be really easy. Here we’re going to quickly cover both, but if you already have a handle on one of the visual editors and are comfortable with finding out what schema is available feel free to skip this part and move on to the Basic SQL Practice Grounds. Typically using a visual tool is much easier, but it’s totally up to you. You can browse a schema visually using popular database interfaces like PGAdmin, Postico and Chartio, or in a text-based manner by using SQL itself. ![]() ![]() When you’re working with a set of data, it’s useful to be able to browse that schema to get a sense for what data is available to you. A database instance may have several different schemas. The word SCHEMA is used to describe a collection of tables and their relationships in your database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |