postgrest_sync_client_select_query_quickstart.py

1import asyncio
2from postgrest import SyncPostgrestClient
3
4# Initialize the client with your PostgREST server URL
5# In a real scenario, you would also provide a JWT token if authentication is enabled
6url = "https://your-postgrest-endpoint.com"
7headers = {"Authorization": "Bearer YOUR_JWT_TOKEN"}
8
9def main():
10    with SyncPostgrestClient(url, headers=headers) as client:
11        # Example: Fetching data from a table named 'countries'
12        # This mirrors the PostgREST 'GET /countries?select=name' request
13        response = client.from_("countries").select("name").execute()
14        
15        # Access the returned data
16        data = response.data
17        print(data)
18
19if __name__ == "__main__":
20    main()